Showing results for 
Search instead for 
Did you mean: 

I need to sort several fields in my report

Former Member
0 Kudos

I use Crystal Report XI and I created a report. Now I want to put sort option on 4 fields. I tried many ways but couldn't find a solution .please help me .

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Hi Niloufar,

Could you please elaborate of what you're trying to do?

If you're simply trying to sort the report on four specific fields, go to the Record Sort Expert and add the four fields to the sort list.


Former Member
0 Kudos

Hello ,

I have a report based on Commodity( with Count , Amount , Margine , margine% ) , now it is sorted by Commodity but I want to give the chance to the user that sort it based on amount or even margine% when they run the report .

I made a parameter ( drop down with these three items : commodity , amount , margine%) , then I Created a formula and this is the code :

If {?Sort - COMMODITY} Then {Command.COMMODITY} Else If {?Sort - INVOICE_AMT} Then TOTEXT({Command.INVOICE_AMT}) Else TOTEXT({@Margin%})

then I went to Record Sort Expert but I don't have my formula here :(:(:(

Thank You