SQL/MX Report Writer Guide

Introduction to the NonStop SQL/MX Report Writer
HP NonStop SQL/MX Report Writer Guide527194-002
1-7
Default Layout and Style Options
The WHERE clause also specifies that rows of the PARTS table are joined with rows of
the ODETAIL table when the rows have the same part number.
The components of the default report are:
Detail lines
°
Each detail line contains all elements of the select list in the order you specify
in the SELECT command. (In Figure 1-2, the columns of data correspond to
the data items as they were listed in the SELECT command.)
°
Values are displayed in the default display format, which is determined by the
data type defined for the column in the table definition.
°
The width of a report column is equal to the heading or item width, depending
on which is wider. Report columns are separated by two spaces. Numeric
items are right justified, and character items are left justified.
°
Lines are single spaced. If the print line does not fit within the left and right
margins, the line is folded according to the current setting of the LOGICAL
_FOLDING option.
Headings
°
Each element that is a table or view column has a column heading consisting
of a heading or column name as defined in the catalog. An element that is an
expression or numeric parameter has the default heading (EXPR). Headings
are underlined and separated from the detail lines by a blank line.
Default Layout and Style Options
For a complete summary for all layout options, see Layout Options on page 1-16.
Report Element Default Setting Result Option to Set
Left margin 0 (zero) The output line begins at the
left edge of the screen or
printed page.
LEFT_MARGIN
Right Margin Width of the
output device
The output line ends at the
right edge of the screen or
printed page.
RIGHT_MARGIN
Page length 60 Displays/prints the number of
lines to which
PAGE_LENGTH is set.
PAGE_LENGTH
Top margin 1 (one) Displays/prints one blank line
at top of report.
PAGE TITLE
Bottom margin 1 (one) Displays/prints one blank line
at bottom of report.
PAGE FOOTING