SQL/MX Report Writer Guide

Using MXCI and the Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
2-9
Defining a Window for Report Output
At the select-in-progress prompt only, you can define a window by the column name or
column number of the left most select item you want to display. For example, to display
the fourth column of the select list, enter:
S> SET LAYOUT WINDOW COL 4;
Figure 2-4 illustrates the relation of the left edge of a window to the output line of a
report. At each numbered step, the headings and first row are displayed.
At Step 1, these layout options are in effect:
•
The left margin is 5. Five blank positions of the output line precede the detail line
content.
•
The right margin is 120. The output line ends at column 120. If the information in
the detail line does not fit on one line, it continues on the next line at the left
margin.
•
The default device width for the terminal is 64.
•
The default window begins at position TAB 1 (the first print position), which is in the
margin.
•
The first detail line begins with the department number field, which is 7 characters
wide. The number is right justified.
At Step 2, the window is specified to begin at TAB 15.
At Step 3, the window is specified to begin at column EMPNUM.
At Step 4, the window is specified to begin at column FIRST_NAME.
For an overview of how to set margins, see Setting Margins on page 4-2.