Specify Sort Columns
Sort columns may be table columns or calculated fields created in the document. Sort columns determine the ordering of data in a report. When more than one sort column is specified, the higher on the list an item appears, the more significant the item; for example, if you sort by student name, “course” generates output ordered by student name and, within each name, by course.
To specify table sort columns
1. Click Edit, Sort in the Query Editor.
Note: You can also access the Reporter Sort Columns dialog by clicking Edit, Query Edit Sort.
The Reporter Sort Columns dialog appears.
• In the Show field, All Columns in Selected Tables is displayed. You can click the down arrow to select Column/Expression in Select Clause.
• Selecting All Columns in Selected Tables lets you select table and column names. Selecting Column/Expression in Select Clause only lets you choose alias names.
2. Select a table name.
The columns associated with the selected table appear in the Column Name field.
If you selected Column/Expression in Select Clause, select an alias name and skip to Step 4.
3. Select the column name that you want to add to sort columns.
4. Click Add to Sort Columns.
The selected column (or alias) name appears in the Alias field in the lower section of the dialog.
5. Repeat steps 2 through 4 for each column you want to add to sort columns.
If you want to remove any columns from the list, select the column name and click Remove from Sort Columns.
If you attempt to remove a column that has been defined as a break column, a Message pop-up appears.
Click OK to close the Message pop-up.
6. Click the up or down arrows to change the order of the sort columns.
Clicking the up arrow moves the selected item up one line. Clicking the down arrow moves the selected item down one line.
7. Click the toggle field under Order Type to select ascending or descending sort order for each sort column.
The default is asc (ascending).
8. Click OK to return to the Reporter Join Query Editor.