The Order By tab determines if and how the rows in a report are ordered. This tab is not displayed when you are designing a cube or crosstab.
Each column you add to the Sort: list is used as a sort key by the database system. The top column in the list is the highest order sort key, and the bottom column is the lowest order sort key. The Order By tab is shown below.
|
|
Figure 77: Order By Tab |
You can select ascending order (lowest to the highest values) or descending order (highest to lowest values). The behavior of the ordered column depends on the type of column. Numbers, characters and dates are all sort differently. Refer to your database reference manual for details of the sorting sequence used for the different data types.
When Selected Columns is selected in the Column Sources: drop-down list, the Available Columns field lists all of the columns selected in the Columns tab.
You can view all of the columns in a table by selecting the table name from the Column Sources: drop-down list. The Column Sources: drop-down list only displays the tables selected in the Tables tab.
To place a column in the Sort: list, highlight the column in the Available Columns: list and click the Add button. Highlight a column and click Remove to remove a column from the Sort: list. You can also double-click the column name to add or remove it.
To move a column up or down in the Sort: list, highlight the column and click the Move Up or Move Down buttons. These buttons are located under the Sort list and are shown below.
|
|
|
Figure 78: Move Up and Move Down Buttons |
The arrow directly to the left of the column name in the Sort: list indicates whether the column is to be sorted in ascending or descending order. An upward facing arrow indicates that the column is to be sorted in ascending order, and a downward arrow indicates that it is to be sorted in descending order. To switch from ascending to descending order, highlight the column in the Sort: list and click the Descending button. To reverse this operation, click the Ascending button.
Break reports (summaries of the data returned from the database) sort in a different way to normal reports.
You do not need to specify the sort order for columns that you want to include in a break report. The break report formatting overrides any sort order you may have specified using the Order By tab.
You can disable the sort operation of the break level column in the Report tab, as described in Disabling Break Level Column Sort on page 183.