Sort a Report

If a report's Modify Report window does not have a Sort Report option, the report cannot be sorted.

1. Open the Modify Report window for the report you want to sort.
2. Click Sort Report on the left side of the window.
3. Select Custom sort order. You can sort the report by a maximum of four columns.
4. Select the Sort by options from the list.

To clear (empty) a sort box, select the blank entry at the top of the list.

5. (Optional) Click the sort button to switch between ascending and descending order:
• When the sort button looks like this, your report is sorted in ascending order, from A to Z. Numbers appear before letters, ordered from 0 to 9.
• When the sort button looks like this, your report is sorted in descending order, from Z to A. Numbers appear after letters, ordered from 9 to 0.
6. Click OK to display the report.

Sorting a report in the report viewer clears any multi-column sorting you have done in the Modify window.

1. Click on the header of the column that you want to sort the results by (for example, Total).
2. (Optional) Click on the header again to switch between ascending and descending order.
3. (Optional) Click the header a third time to return to the report's original sort order.