SQL/MP Report Writer Guide

Customizing a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
4-9
Defining the Layout
LINE_SPACING
This layout option indicates to the report writer how many lines to
advance between report lines. The default setting for
LINE_SPACING when you begin an SQLCI session is 1, which
results in a single-spaced report. For double spacing, enter the
following:
>> SET LAYOUT LINE_SPACING 2;
SKIP clause
You can specify a SKIP clause as a print item in a detail line, title,
or footing. SKIP advances the number of lines you specify before
displaying or printing the next item. The LINE_SPACING option
defines the increment for the SKIP clause.
For example, suppose LINE_SPACING is 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 1, STREET,
+> SKIP 1, CITY, STATE, POSTCODE;
If you set LINE_SPACING to 2 before printing the report, a blank
line appears between each output line. SKIP 1 advances 2 lines
(SKIP
number * LINE_SPACING number).
SPACE option
The SPACE layout option specifies the default number of single-
byte spaces between print items of a detail line as follows:
>> SET LAYOUT SPACE 3;
The number you specify stays in effect until you end your SQLCI
session or change the number. The default setting when you begin
an SQLCI session is 2 spaces. The report writer does not insert
spaces preceding or following a string literal unless you specify a
heading for the string.