cancel
Showing results for 
Search instead for 
Did you mean: 

I need to sort several fields in my report

Former Member
0 Kudos
69

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)

abhilash_kumar
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.

-Abhilash

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