The Sort Expert is launched from a button on the Experts toolbar, and also via the Record Sort Expert item on the Report menu. Figure 3.5 shows the Sort Expert.
Figure 3.5. The Sort Expert dialog accessed from the Report menu.
To apply sorting to the report, select a field from the list of available fields on the left side of the dialog area, and click the arrow (>) button to add that field to the Sort Fields list. Note that like filters, sorts can use fields both on the report and fields not otherwise used in the report.
In addition to sorting on report and database fields, you can sort on formula fields. Creating a formula field enables you to sort a report based on a custom expression.
To see this in action, follow these steps:
The Sort Expert enables you to sort on both alphabetic and numeric fields. To modify this report to sort on salary instead of last name, follow these steps:
Notice that some employees have the same salary level. If you wanted to perform a secondary sort within duplicates of the primary sort field, you can simply add another sort field. These sort fields can be arranged up and down using the buttons near the top-right corner of the Sort Expert.