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