I have the following issue.
I have a reporting layout that users can choose a 'date range', 'status' and 'sort by1' 'sort by 2'. Once they have selected they hit "process report" and it send them to the correct layout and performs a find based on their selections. the script sorts based on what they entered into the "sort field". it could be "state" , "City", etc.
The layout has subsummary parts for every option the user can choose. My question is how do I perform 2 sorts in a script so that two subsummarys show up.
For instance, ::sort1 = city and ::sort2 = salesperson, indicating the user wants to sort the cities by salesperson.
Is there a way to do this in a script without having to write an "If" statement for every combination of sort data that could be entered by the user?