Previous Topic: Data Retrieval CommandsNext Topic: Report output commands


Report formatting commands

You can specify the display format of reports containing data retrieved by CA OLQ commands. The following table presents the commands available for formatting reports in CA OLQ.

Use ...

To ...

COMPUTE

Perform computations on fields in a report file by using:

  • Arithmetic expressions

Built-in functions

COMPUTE ... GROUP BY

Perform summary computations.

DELETE COMPUTATION

Delete computed fields.

EDIT

Edit a field for display by specifying:

  • Edit characteristics, such as hexadecimal display, lead zeros, commas, a specific external picture, and a code table translation
  • A report heading
  • Sparse, to suppress the display of repeating column values

The alignment of a column

EDIT COMPUTATION

Edit a computed field for display by specifying:

  • Edit characteristics, such as hexadecimal display, lead zeros, commas, a specific external picture, and a code table translation
  • A report heading
  • Sparse, to suppress the display of repeating column values
  • The alignment of a column

The column under which a computed field is displayed

EDIT GROUP BY

Edit the group defined by the COMPUTE...GROUP BY command. Use this command to change the level number of a group, specify spacing between groupings or specify the separator character which separates the grouping from the computed value.

ON BREAK

Display computed values at designated points within the report file. This command is provided for compatibility with prior releases but its use is discouraged. Use COMPUTE...GROUP BY instead.

PAGE HEADER/FOOTER

Include a user-specified page header or footer in a report.

SORT

Request that records within a report file be ordered by user-specified order criteria.

UNSORT

Return the report file to the original retrieval sequence following one or more SORT commands.

For more information:

Commands and Syntax