The functions Sort in Ascending Order and Sort in Descending Order sort the report rows in ascending or descending order for one or more columns.
Sorting Rows in a Column in the List
The rows are sorted in the column selected.
If you use this procedure in a multilevel sequential list, you can sort by a maximum of one header column and one subordinate row.
Sorting According to Multiple Columns or Fields Not Displayed
You select the sorting fields in multilevel sequential lists separately for header and item.
You want to sort a list by cost centers and activity types. In the dialog box, choose the cost center and activity type as the sorting criteria. In the list of selected sorting fields, the cost center must be above the activity type. Use the radio buttons to specify ascending sequence. The result is a list sorted by cost center. The activity types are listed in ascending order for every cost center.
If you use this procedure in a multilevel sequential list, you can sort by multiple header columns and item columns.
If you have sorted according to particular fields, you can obtain an overview of the current sort with Sort in Ascending Order or Sort in Descending Order. The dialog box Define Sort Order appears. The left half of the window shows all fields that were sorted by.
You can also use the List Status function for an overview of the selected sort criteria.
After sorting, you can create subtotals on selected fields. (See also:Creating Subtotals)