SQL/MP Report Writer Guide

Introduction to the NonStop SQL/MP Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
1-13
Report Writer Components
Style Options
Style options control the appearance of print items in a report. The style options are
summarized in Table 1-3.
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.
SKIP Advance a specific number of lines before printing the next print
item
SPACE Number of blanks to print before the next print item
TAB Print position of the next print item
Note. For detailed descriptions of the NEED, PAGE, SKIP, SPACE, and TAB clauses, see the
DETAIL command in the SQL/MP Reference Manual.
Table 1-3. Style Options
Style Option Default What the Option Defines
DATE_FORMAT M2/D2/Y2 Default format for date values
DECIMAL_POINT Period (.) Single-byte symbol for decimal point
HEADINGS ON Whether headings are generated
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-2. Report Formatting Command Clauses (page 2 of 2)
Clause What the Clause Specifies