How To Sort At Runtime 1

[bburnell]

Can sorting be done based on an input parameter in CR 8.5 and VB 6?
Thanks!
Brett (smsforce) E-mail me at smsforce@smsforce.com

Please visit my websites!

http://www.smsforce.com

http://geocities.com/emushoppe

 

[paulmarr]

Brett,

Group your data on a formula based on a parameter the user chooses, something like:

If {?parameter}={db.field1} then
{db.field1}
else if {?parameter}={db.field2 then
{db.field2}
else if .... and so on.

Hope this helps

paulmarr

 

[bburnell]

Hi paulmarr,
Thanks for the response. This definitely is what I need, but where do I put the formula at?
Thanks in advance!
Brett (smsforce) E-mail me at smsforce@smsforce.com

Please visit my websites!

http://www.smsforce.com

http://geocities.com/emushoppe

 

[bburnell]

I think we figured it out. You put the formula in a formula field and then group by that formula field. Thanks a lot for the help!
Brett (smsforce) E-mail me at smsforce@smsforce.com

Please visit my websites!

http://www.smsforce.com

http://geocities.com/emushoppe

 

[kkashwani]

If your using RDC for generating Crystal report in your VB appication then use below code
You can put code like this in the General Declarations section.

Dim CRXReport As New CrystalReport1
Dim CRXDatabaseField As CRAXDRT.DatabaseFieldDefinition
Private Sub Form_Load()

Currently there is no sort in this Report. To add the sort field Customer Name, the application must first get the {Customer.Customer Name} field from the Customer Table. This code accesses the first table to get the 2nd field.

Set CRXDatabaseField = CRXReport.Database.Tables.Item(1).Fields.Item(2)

Now add the field to the SortFields Collection and set the Sort Order to ascending.

CRXReport.RecordSortFields.Add CRXDatabaseField, crAscendingOrder