Scripted sorting, sort of?

[Rich S]

Howdy, all:

I'm creating a run-time solution where a user will be printing a report that has four different fields in it. What I'd like to have users be able to do is select the sort order without having them manually set it up using the Sort Field command/script step.

The four fields are: Cost_Category, Cost_Type, Date, and Record_Number. Ideally, there'd be a pop-up menu adjacent each field with each menu having a value list numbered 1, 2, 3 and 4. In practice, the user would choose the order of the sort based on the value list selections, click the report's script button, and away she goes.

Obviously, there's gotta be a better way than scripting for 24 permutations here. I've perused the threads here and haven't quite found what I'm looking for, so any guidance will be greatly appreciated!