Record Sort Expert
Use the Record Sort Expert to define how you want the records in your report to be sorted for printing. A sort field is a data field on which the sort procedure is based. You can add and remove sort fields and define the sort direction (ascending or descending) for the data in your report.
This dialog box appears when you right-click in the Report Designer, point to Report, and click Record Sort Expert.
| Available Fields | Displays a list of the report fields currently in the report as well as those available in the report's data source tables. |
| Sort Fields | Displays a list of the sort fields currently in the report. |
| Add (>) | Adds the selected report field to the Sort Fields list. |
| Remove (<) | Removes the selected sort field from the Sort Fields list. |
| Sort Direction | Sets the sort direction to ascending or descending. |