Previous Topic: How to Format Your ReportNext Topic: Creating a Report


Key Terms

Code table

A table that is defined in the data dictionary and that contains corresponding pairs of values. For example:

Internal      Displayed
  Code         Value
________      _________
01            Alabama
02            Alaska
03            Arizona
.             .
.             .

Internal codes are used to efficiently store the data in the database. External values are used to display data in programs or reports.

Column alignment

A way to specify how report data columns align under the column headers. Options are left-justified, right-justified, and centered.

Column header

A header at the top of each column of report data.

Display sequence

Determines the order in which report columns are displayed.

External picture

A code that defines the way your column value is formatted in your report. The external picture is used to add punctuation (for example, commas) and special characters (for example, dollar signs) to your column data display.

Page header

A title at the top of each page of your report.

Page footer

A title at the bottom of each page of your report.

Sort

A way to order report rows. CA OLQ sorts the rows in your report based on the value of the sort fields that you specify. Rows can be sorted in ascending or descending order.

Sparse/Full option

A CA OLQ editing feature that determines how column values that repeat in consecutive rows are displayed: