Release 10.1A: OpenEdge Reporting:
Query/Results for UNIX

> ## Changing the order of records in a report

> This section describes how to change the order of records in your report. You can order records by as many as five fields.

> | To change the order of records in your report:

> 1. Select the Order option.

> A window appears that lists all of the fields in the active files. You can use any of these fields to change the order of the records in the report.

> Also, you can order records by more than one field. For example, you can put the records in order by state, and by customer number within each state.

> 2. Select the first field you want to use to order the records.

> As you select the fields for the report, Results numbers them in the order you select them. If you select a field by mistake, highlight it again and press RETURN to deselect it. You can also type a number next to the field, and the other selected fields will renumber automatically.

> 3. Continue to select the fields in the sequence you want to order the records.

> 4. Press GO when you are done.

> A window appears that lets you choose the order (ascending or descending) for each order field:

> 5. Enter the type of order you want for each field.

> For example, if you put character fields in descending order, they appear in the report in reverse-alphabetical order.

> 6. Press GO or RETURN to apply these changes.

> The order definition appears in the Report Info window. For example, this figure shows a sample order definition:

> This order definition tells you that the lines in the report are in order first by sales region, then by customer number within each region. (In each case, the field name is prefixed by the name of the file and the database that contains it.)

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095