SQL/MX Report Writer Guide

Introduction to the NonStop SQL/MX Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
1-8
Customized Reports
For a summary of layout and style options, which includes the default setting of each
option, see Report Writer Components on page 1-12. For detailed information about
layout and style options, see the SQL/MX Reference Manual.
Customized Reports
By entering report formatting commands, you can define these additional report
elements:
•
Page title: A title appears at the top of each page.
•
Report title: The main title of the report appears at the top of only the first page
(below the page title, if there is one).
•
Detail lines: A detail line is printed for each row of the result table described by the
select list in the SELECT command. You can:
°
Include items from the select list, expressions, or literals.
°
Connect two or more print items, omitting intervening blanks.
°
Specify conditions for printing items.
°
Define headings and names for items.
°
Use positional clauses like SKIP and PAGE to control the position of the next
detail item.
•
Break groups: A break group consists of all detail lines with the same value in a
specific column (the break column).
•
Break title: A break title precedes the first line of a break group.
•
Break footing: A break footing follows the last line of a break group.
•
Subtotals for numeric columns can be calculated when the value of a specific
break column changes or each time any break column value changes. A subtotal
appears after the last line of the break group you specify.
•
Totals: Any numeric column in the detail line can have a total value calculated and
printed following the last detail line in the report.
•
Report footing: A report footing appears at the end of the report (above the page
footing, if there is one).
•
Page footing: A page footing appears at the bottom of each page.
For more information on report formatting commands, see Report Writer Components
on page 1-12.
A Sample Formatted Report
Figure 1-3 shows commands to produce a formatted report. Figure 1-4 and Figure 1-5
show the two pages of the resulting report.