Within the Sort Order tab of the Report Definition you can define which columns to sort, how they should be sorted, and in what order to sort them.
Columns that are not listed in the Column Sort Order list will be unsorted, and will appear on the report in whatever order they happen to come in. Generally, it is good practice to sort by at least one column in each report.
Columns can be sorted with values in ascending, or descending order.
Columns listed in the Column Sort Order are listed in the order that sorting will be applied, with the columns at the top of the list sorted first.
Secondary sorted columns are sorted within the previous column order
Here is an exmaple of a report with a secondary sorted column defined. Notice that first the data is sorted by location, then within each location grouping, the data is sorted again by position.
Figure 1. Example of a report with a secondary sorted column.1 First the report is sorted by location, 2 then the report is sorted by position within each location.
Add Sorting to a Column
Choose which columns should be sorted in a report by adding them to the Column Sort Order list on the Sort Order tab.
| 1 | Press Insert. |
| 2 | Select the column to sort from the Column drop-down. |
| 3 | Choose how to sort the column data. |
| 4 | Press OK to save the Sort Order |
|
Column Sort Order If you want to change what order the columns are sorted in you can change the sort order of a column by moving it in the Column Sort Order list. You can move a selected item up or down in the Column Sort Order list by pressing |
