You can sort the report to get the report data in a pre-determined (ascending or descending) order.
Note: If you have setup grouping for a report, you need not set sorting for it. This is because data is already sorted to make groups.
Ad hoc Report Designer supports multiple level of sorting. For example, you can Sort By “Country”; then within “Country”, sort by “State” and within “State” sort by “City”.
If not already expanded, click Sorting tab header to expand it. The number of sort levels you have selected is displayed on right side of the header.
Figure 8: Specifying Sort Order
In Sort By row, select the Field on which sorting is to be applied. After selecting the Field, select the sort order from Criteria dropdown menu. You can set sort on more than one field.
To apply sorting on one field specify field in Sort By row. To set sorting on another field select the field from Then By field.
You can choose to alter given sorting settings at the run time from Power Viewer.