User`s guide

7.
Select Use a Formula as Group Sort Order, and click the Conditional Formula button next to
it.
Note:
This option is not available if you choose "in specified order" as the sort order for your group.
8.
In the Formula Workshop, enter your conditional formula text.
For this example, enter this text:
If {?Sort Order} = "Ascending" then crAscendingOrder else crDescendingOrder
9.
Click Save and close to return to your report.
10.
Click OK to save your group.
11.
When you are prompted to select a Sort Order, select the option that you want, and click OK.
Your report appears with groups for the field that you selected in the Insert Group dialog box and sorted
in the order that you selected in your parameter prompt. To select a different sort order, click the Refresh
button and choose "Prompt for new parameter values." The groups in your report are resorted to comply
with the new order option that you selected.
8.2.4 Sorting records within groups
Once you have grouped your data, you can easily sort the records within the groups to further organize
the information.
8.2.4.1 To sort records within groups
1.
Once the data is grouped, on the Report menu, click RecordSort Expert.
The Record Sort Expert appears.
2012-03-14151
Sorting, Grouping, and Totaling