If you only want to sort a single Request item, report row, or column, you can use the Sort buttons on the toolbar to quickly order the data.
If you apply simple sort conditions in the Query section, the database server sorts the data while processing the query before it is retrieved to your desktop. Or you can sort data on your desktop in Results or report sections. The data associated with a selected item is sorted in ascending or descending order as you wish.
To select items to sort:
In the Query section, select a topic item on the Request line. In other sections, select a corresponding report element in the Content pane.
On the Standard toolbar, click the ascending or descending Sort icon.
The data is sorted in the Content pane.
If the Sort line is visible, the item appears on the Sort line. The item name is followed by an up or down arrow to indicate the sort order.