The values held within a Summary screen can be sorted to present the records in a particular order, alphabetically, numerically and date wise. To activate this just hover your mouse to the right of any column header and two arrows will appear.
Fig 1 - Sorting arrows
Click the arrow to sort the data, clicking again will sort the data in the opposite order.
Fig 12- Sorting the Summary screen
This will allow you, for example, to sort by 'Status', when first pressed the records will be presented as:
- Active
- Closed
- Due
- Future
- Expired
- Draft
If pressed again they will be presented as:
- Draft
- Expired
- Future
- Due
- Closed
- Active
You can only sort by one column at a time. When you have selected a sorting option, the summary screen will stay in that order unless you select another column to sort by.
The records will sort depending or the values held within the column that you are sorting by. The first press will sort the data ascending, the second press will sort descending.
Column Value | First Press | Second Press |
Text | A - Z | Z - A |
Text and Number | A0 - Z99999 | Z99999 - A0 |
Numeric | 0 - 99999 | 99999 - 0 |
Date | Earliest Date | Latest Date |
Date Range | Earliest Date within the Range(s) | Latest Date within the Range(s) |
TIP: any records that have values missing will be presented as the earliest value i.e. higher than A or 0 so will always be presented first or last dependant or the sorting order