After you select the rows to display on your report, you
can specify the way that you want to sort the rows on the report.
About this task
In this example, you sort the rows in ascending order
by department number.
- On the Specify panel, select choice
displays (as shown in the following figure) with choice 1, Ascending
selected for you.
1 selected if you want to sort the
rows in ascending order, or type
2 to sort the rows
in descending order.
- Type the number of the column that contains the data you
want to sort.
- Press Enter.
The sort order that you specified
is displayed in the echo area, and the Specify panel
What to do next
Repeat these steps if you want to sort on other columns.
For example, in this query, in addition to sorting by department number,
you might also want to sort by name within department.
the sort order that you selected, as shown in the following figure.
the report in the following figure when you run this query. The rows
are first sorted by department number, and then by employee name within