I need to sort several fields in my report

[Former Member]

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 .

[abhilash_kumar]

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]

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