Formatting Tab, Report Request Editor

Use the Formatting tab to define formatting and other parameters for the Report Process output.

Report Request Editor with Formatting as the active tab. The elements of the Formatting tab are described as follows.

Limits

The default values for Limits are set on the Report tab in Product Options. Refer to the Installation and Configuration Guide .

Rows per Table
Maximum number of rows (1 to 99999999) that can be reported on during a single Report Process. This setting applies only if the Report Type is File.
Lines per Page
Maximum number of lines per page (50 to 999).
Line Length
Maximum number of characters per line (31 to 999).
Character Column Width
Maximum number of characters per column (1 to 999) for the report. This setting applies only if the Report Type is File.

Spacing

The default values for Spacing are set on the Report tab in Product Options. Refer to the Installation and Configuration Guide .

Blank Lines Between Rows
Number (0 to 9) of blank lines between rows.
Minimum Spaces Between Columns
Number (0 to 9) of blank spaces between columns.
Blank Lines Between Levels
Number (0 to 9) of blank lines between each level of related tables, when Show joins is selected, and related tables are joined.
Spaces to Indent Subordinate Tables
Number (0 to 9) of spaces to indent subordinate rows.

Adjust Oversized Lines

Options for handling lines that exceed the limits of the report page are handled.

Truncate
End each report row after the maximum number of characters (including spaces) per line is reached.
Wrap
Wrap each row to the next line of the report when the row length exceeds the maximum number of characters (including spaces) per line.

Show Table Headings

Provide column names with data reported from the Start table.

Show Subordinate Table Headings

Provide column names with first joined row.

Show Redundant Table Headings

Include column names with every row of related data reported from a joined table.

Get Site Defaults

Inserts Limits and Spacing defaults as set in Product Options. Refer to the Installation and Configuration Guide .