Enabling multiple option in sort by

[Marwa_Mohamed]

I have create a BAQ report designer, and I want to allow users to select multiple options in the “Sort By”. Can you suggest how I can achieve this?

Please refer to the attached picture for a better understanding.

[MLamkin (Marjorie Lamkin)]

Usually when I have something like this, I make a variable that can be set to the appropriate value (based on the selected criteria) and sort by that variable. Something like SortVal = CASE WHEN SelSort = ‘Customer ID’ then CustID WHEN SelSort = ‘Customer Group’ then Customer Group etc. Then sort on SortVal.