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 8,149
1 Sergey Alexandrovich Kryukov 7,287
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,910


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.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