Records ordering allows you to prioritize the appearance of specific pieces of information in the report. Records are sorted so information can be presented in a way that is most helpful to the reader. In the following example, records will be sorted so customers with greater outstanding balances are listed first.
To set record sort order:
1. Open the Record Sort Order window by clicking .
The Record Sort Order Window appears:
2. Move the fields you want to sort to the Sort Fields area by selecting them from the Available Fields list and then clicking >. The field names move to the Sort Fields area:
3. Select the field when it is the Sort Fields area, and then choose Descending from the Sort Direction options. Click OK when finished. Records in the report are now grouped by state and each state's records are ordered from those with the largest to smallest account balances:
.
