URGENT HELP - Conditionally sort List of Values

[bunnycat]

Is there a way to conditonally sort a dynamic cascading prompt group. For example, we would like to give the user the option to sort a pick list by a person name or the employee id. If they select person name, they will see the list in name order or if they select employee id, they will see the pick list in employee id order.

 

[Madawc]

You could do it using a parameter that selected a sort option. Group or sort using a Formula Field that uses different data fields depending on the parameter chosen.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[bunnycat]

I am familiar with using the sort option parameter within the report formula but is there a way to get the user entry and sort the pick list in response to their sort option selection? How do you pass that parameter to a dynamic cascading prompt because I want to change the way the pick list is sorted dependent upon the parameter selected in the sort option parameter<