Sorting the elements in a report

In the Sort Options section of the prompt page, you can choose the columns on which to sort a report.

Drop-down lists appear at the bottom of each report prompt page. Default sorting selections are automatically selected. You can change these to create your own report definition.

Each sort drop-down list includes Ascending and Descending radio buttons. Ascending sorts are automatically selected by default. Use the radio buttons to change the sort type.

Reports that include groupings, such as organization by user or by site, are sorted at the detail level within the grouping, according to the selections made in the drop-down lists. The grouping sort order can be modified (ascending or descending) but will always take precedence over other sorting settings.

Note: You can also sort data based on a report element without first adding the element to the report. For more information, see Sorting data without adding a column.