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.