Sort Order

[Former Member]

Hi,

I am trying to add a Parameter Sort Order. The existing report sorts by Salesperson, Customer, Item then Year Period. I added a parameter prompt.

SortbySlpsZip (Yes or No) I would like if 'No' is chosen the report prints as is, If 'Yes' is chosen the sort by Salesperson,Customer, ZipCode, item then Year Period.

So far I have not figured out how to do this correctly. Can someone help me set this up correctly ?

Thanks,

Debbie

[abhilash_kumar · Accepted solution]

Hi Debbie,

Here's what you need to do:

1) Create a formula with this code:

If {?SortbySlpsZip} = "Yes" then

     {Database_Field_for_Zip}

else

     ""

2) Go to the Record Sort Expert > Add this formula field after the 'Customer' field in the list.

-Abhilash