SQL/MX Report Writer Guide

Introduction to the NonStop SQL/MX Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
1-16
Layout Options
Layout Options
Layout options control the appearance of a report on the screen or printed page. The
layout options are summarized in Table 1-4.
NEWLINE_CHAR Slash (/) Single-byte character to indicate a new line
in a heading
NULL_DISPLAY Question mark (?) Single-byte character to represent null values
OVERFLOW_CHAR Asterisk (*) Single-byte filler character printed when a
value exceeds a field size
ROWCOUNT ON Whether the row-count line is generated
SUBTOTAL_LABEL * Label to print in a break column when a
subtotal is printed
TIME_FORMAT HP2:M2:S2 Default format for time values
UNDERLINE_CHAR Hyphen (-) Single-byte character to be the underline
VARCHAR_WIDTH 80 Maximum number of characters in a variable-
length print item
Table 1-4. Layout Options
Layout Option Default What the Option Defines
CENTER_REPORT OFF Centering of the entire report
LEFT_MARGIN 0 Left margin of the report
LINE_SPACING 1 Number of lines to advance before the next
line
LOGICAL_FOLDING ON Whether an item of the default detail line
moves to the next line when the item does
not fit within the margins
PAGE_COUNT ALL Maximum number of pages
PAGE_LENGTH ALL (terminal)
60 (other devices)
Number of lines per page
RIGHT_MARGIN Output device
width
Right margin of the report
SPACE 2 Number of single-byte spaces between
columns
WINDOW TAB 1 Print item or print position to display at the
left edge of the output device
Table 1-3. Style Options (page 2 of 2)
Style Option Default What the Option Defines