Previous Topic: FOR Operand-Limit the Identifiers Included in a ReportNext Topic: TOP and BOTTOM Operands-Limit Reports

Tabular Reports › Limit the Contents of a Report › FOR Operand-Limit Reports Organized by Time and Date

FOR Operand-Limit Reports Organized by Time and Date

To limit reports organized by time and date, use the FOR operand. The time periods included in the report contain the highest value for the variable that the FOR operand is specified with.

The following commands produce a report limited to the five times with the highest values for the variable:

TAB DATETIME TRAN USE FOR 5
    EACH 1 HOUR
END
RUN

A report like the following is generated:

                  TRAN
  DATE    TIME     USE
-------- -----  --------
02/22/08 03.00     42
02/22/08 04.00     19
02/22/08 06.00     29
02/22/08 11.00     16
02/22/08 15.00     20
-------- -----  --------
PERIOD            126
-------- -----  --------