SORT

Describe a sort field

SORT field_spec [REVERSE] [LINEBREAK] [PAGEBREAK] [MERGE]
[BY field_spec [REVERSE] [LINEBREAK] [PAGEBREAK] [MERGE]...]

field_spec

A specification for a field in a report. See Field_spec definition.

REVERSE

(optional) Reverses the sort order of the current sort field.

LINEBREAK

(optional) Inserts a line break in the report whenever the value of the current sort field changes.

PAGEBREAK

(optional) Inserts a page break in the report whenever the value of the current sort field changes.

MERGE

(optional) Allows multiple projection files to be treated as one for the purpose of sorting.

BY

(optional) Indicates that another sort field will follow.

The SORT statement describes a sort field. Sort fields help control the organization of a report. The order in which the sort fields are specified determines the sort levels within a report. The maximum number of sort fields is 10.

SORT CUST_TAG.STATE
SORT CUST_TAG.CITY BY CUSTOMER.CUST_NAME LINEBREAK