Click here to Skip to main content
13,089,818 members (45,206 online)
Rate this:
Please Sign up or sign in to vote.
i am converting a program from vb6 to 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 2:54am

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.170813.1 | Last Updated 20 Oct 2012
Copyright © CodeProject, 1999-2017
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