SQL/MX 3.2 Report Writer Guide (H06.25+, J06.14+)

Introduction to the NonStop SQL/MX Report Writer
HP NonStop SQL/MX Release 3.2 Report Writer Guide—691130-001
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.