- Go to Insert > Group
- From the first drop down, select the field you want to sort the report by
- From the second drop down, choose the sort order (ascending, descending, specified, original order)
- Click OK
- For a secondary sort, simply insert another group (this will become Group #2, the report will sort by this field after the first/primary group)
To sort the report using Sort Records:
- Go to Report > Record Sort Expert
- Select the field you would like to sort on from the Available Fields list on the left
- Click the right arrow button to bring the field to the Sort Fields list on the right
- Select the Sort Direction: Ascending or Descending
- Click OK