Restricting and Ordering Data Values
You can perform conditional retrieval and data sorting in reports by using the commands listed in Table 108:
Table 108. Report Writer Commands: Data Value Restriction and Ordering
Report Command | Description |
---|
TOP | Specify the number of rows to return. These rows must contain the top values of a specific data column. |
BOTTOM | Specify the number of rows to return. These rows must contain the lowest values of a specific data column. |
RESTRICT | Specify the conditions the columns of a data row must satisfy before the row is returned. |
ORDERBY | Specify the ordering of the rows of a report, based on the data values of data columns. |
Configurable variables are used during conditional retrievals. See Changing Buffer Size.