Can I define sort-order at runtime?

[CInman]

With a Crystal 7 report, can I somehow define the sort order of the DETAILS section at runtime? I suspect it may be something to do with Groups and "in specified order", but I cannot work it out??

 

[BFAGG]

1. Create a parameter called 'Sort_order' of type string. Set default values for all the sort orders eg; Surname, Firstname.

2. Create a formula called 'Sort_by'. This should be something like:
If {?Sort_order} = 'Surname'
then {tablename.surnamefield}
else If {?Sort_order} = 'Firstname'
then {tablename.firstnamefield}
else etc;

3. Specify the sort order of the report to be {@Sort_by}

 

[CInman]

Thank you for your update - so can I specify the sort order too like this?

 

[BFAGG]

Yes. Point 3 needs more explanation:

Go to the menu Report->Sort Records option.

The formula {@Sort_by} will be available from the field list in the left hand side of the window.

Selecting this field will cause the report to be sorted on whatever the user selects.