SQL/MX Report Writer Guide

Customizing a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
4-5
Setting Margins
If you specify text in the title line, specify PAGE TITLE SKIP desired-margin-
size - 1, ' text'. For example, to produce a desired margin size of 4 lines (SKIP
4 - 1 = SKIP 3), enter:
S> PAGE TITLE SKIP 3, 'Summary of Employees'; (
4 blank lines appear here. )
Summary of Employees
CUSTNUM CUSTNAME
------- --------
In this case, the four blank lines are created as follows:
•
The first blank line is the default top margin.
•
The next three blank lines are the specified skips.
•
The blank line following the title is the default skip that always follows the title line.
Use the same technique for bottom margins, except SKIP follows the footing text if
specified.
In the next example, the page footing is positioned above a bottom margin of 3 lines (2
lines specified by SKIP 2 and 1 line, which is the default bottom margin):
S> PAGE FOOTING 'Page ', PAGE_NUMBER AS I2 , SKIP 2;
.
.
Page 1
( New page starts here. )
For more information about these commands, see Specifying Titles on page 4-20 and
Specifying Footings on page 4-24.