SQL/MX Report Writer Guide

Customizing a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
4-10
Spacing Items and Lines
Spacing Items and Lines
The report writer features that control spacing of print items and lines are:
LINE_SPACING Sets the number of lines to advance between report lines.
Default setting = 1 (a single-spaced report)
For double spacing, enter:
>> SET LAYOUT LINE_SPACING 2;
SKIP clause Specifies the number of additional times to invoke LINE_SPACING
to create extra space before displaying or printing the next item in
a detail line, title, or footing.
Use the clause:
SKIP number
number is a multiplier to be used with the current value set for
LINE_SPACING. The default value is 1.
For example, if LINE_SPACING is set to 1, the following detail line
specifies that the supplier number and name appear on one line;
the street on the next line; and the city, state, and postal code on
the following line:
S> DETAIL SUPPNUM, SUPPNAME, SKIP, STREET,
+> SKIP 1, CITY, STATE, POSTCODE;
If you set LINE_SPACING to 2 before printing the report, SKIP
causes a blank line to appear between each output line. SKIP 3,
however, advances 6 lines, so 5 blank lines appear between each
output line.
SPACE option Specifies the default number of single-byte spaces between print
items of a detail line:
>> SET LAYOUT SPACE 3;
Default setting = 2 (at the beginning of an MXCI session)
The number you specify stays in effect until you end an MXCI
session or change the number.
The report writer does not insert spaces preceding or following a
string literal unless you specify a heading for the string.