SQL/MX Report Writer Guide

Customizing a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
4-20
Specifying Titles
+> PARTCOST * QTY_AVAILABLE
+> HEADING 'Total Cost/(dollars)' CENTER;
S> LIST N 1;
Part Available Unit Cost Total Cost
Number Units (dollars) (dollars)
------ ----------- ------------ --------------------
212 3525 2000.00 7050000.00
S>
To specify a different new-line character, enter:
>> SET STYLE NEWLINE_CHAR '!';
The first line of the DETAIL line must then be changed:
S> DETAIL P.PARTNUM HEADING 'Part!Number' CENTER,
Specifying Titles
A report can contain three types of titles:
•
A page title appears at the top of each page of a report. Only one PAGE TITLE
can be in effect at a time.
•
A report title follows the page title on the first page of the report. Only one
REPORT TITLE can be in effect at a time.
•
A break title precedes the break group for which it is defined. There can be one
BREAK TITLE command for each item specified in a BREAK ON command.
You can edit a command by using FC, replace a command by reentering it, or delete a
command by using RESET REPORT.
Page and Report Titles
To produce a page and report title for the supplier parts summary, enter:
S> PAGE TITLE 'Supplier Parts Summary' CENTER;
S> REPORT TITLE 'Date: ', CURRENT_TIMESTAMP AS DATE *,
+> TAB 40, 'Author: Sarah Verdi';
The right margin is 65. The page title is centered. Titles on the first page appear as
shown in Figure 4-7
.