Sorting the records
Use the Sorting and Formatting page to specify how the records are sorted on the report— there are three levels of sorting.
About this task
This example shows sorting in ascending order (that is A before B):
| Primary | Secondary | Tertiary |
|---|---|---|
| A | A | A |
| A | A | B |
| A | B | A |
| B | B | B |
Procedure
- Click the Entity tab or the Links tab, and then the Sorting and Formatting tab to display the Sorting and Formatting page.
-
Turn on or off the sorting options:
Option Description Option Description Sort by In the Sort by drop-down list, select the field that you want to sort by.
Records in the report are sorted first according to their value in this field, in either ascending or descending order:
- Click Ascending to sort a before z, and 1 before 9.
- Click Descending to sort z before a, and 9 before 1.
Then By In the Then by drop-down list, select the next field that you want to sort by. If there is no suitable field, select <None> from the drop-down list.
Records that are placed in the same position by the primary sort are then sorted according to the field that you select here.
Then By If required, in the second Then by drop-down list, select another field to further sort the records or select <None> from the drop-down list.
Records placed in the same position by the primary and secondary sorts are then sorted according to the field that you select here.