Skip to Content
avatar image
Former Member

I need to sort several fields in my report

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 .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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


    Add comment
    10|10000 characters needed 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