Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
i am converting a program from vb6 to vb.net and it related to crystal report.
 
there is function that allow user select sorting field and user can sort by more than one column. so user can read many records and use sorting to read it. now i use new crystal report dll which is crystal report 13 (should be most update version)
 
CrystalDecisions.CrystalReports.Engine(one of dll)
my question is :
 
in .net or vb6, program can use the method :
 
crystal.set_SortFields(i, strfields(i))
to set the fields which need to sort
 
but in new Crystal report dll, it will not work and need to use new coding...
 
so how can i handle the sorting in report by the report's fields?
 
i try some way:
 
Dim sortfiled As SortFields = reportdocument.DataDefinition.SortFields
reportdocument.DataDefinition.SortFields.Item(0).Field =reportdocument.Database.Tables("tmfphmstr").Fields("sex")
reportdocument.DataDefinition.SortFields.Item(0).SortDirection = CrystalDecisions.Shared.SortDirection.DescendingOrder
this will occurred others error there must be a group that matches this field... so sad now...waste whole day and do nothing...
 
please help, any information you need, just tell me.
 
note: in my .rpt, i did some grouping
Posted 20-Oct-12 3:54am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 375
1 Sergey Alexandrovich Kryukov 329
2 CPallini 260
3 DamithSL 214
4 Maciej Los 197
0 OriginalGriff 5,455
1 DamithSL 4,457
2 Maciej Los 3,885
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,115


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 20 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100