Skip to Content

I need to sort several fields in my report

Aug 17, 2017 at 06:54 PM


avatar image
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 .

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Aug 18, 2017 at 07:31 AM

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.


Show 1 Share
10 |10000 characters needed characters left characters exceeded
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