Sort the Report Rows

By default, reports are sorted in ascending order by the values in the first column, but you can sort the reports based on any report column and in either ascending or descending order.

Sorting is applied to the records currently selected by the standard or custom search you have applied. If you specify a sort order other than the default and then change the search, that sort order is discarded, and the default order is restored. Also, if you log out of iAccess, the default sort order is restored the next time you display the report.

To change the order in which report rows are sorted, complete the following steps:
  1. In the workspace in which the report is located, click to go to the Reporting area.
  2. If the report that displays by default is not the report you want, do either of the following:
    • To display a standard report, click the currently displayed standard report name above the upper-left corner of the report and select the standard report you want.
    • To display a saved report, use the Find saved report field at the top of the Reporting area to select the report.
  3. Click the heading of the column by which you want to sort the report. Result: The report is sorted in ascending order based on the values in the selected column. The sort indicator () displays next to the column heading.
  4. To change the sort order to descending, click the column heading again.