SQL/MP Report Writer Guide
Table Of Contents
- What’s New in This Manual
- About This Manual
- 1 Introduction to the NonStop SQL/MP Report Writer
- 2 Using SQLCI and the Report Writer
- 3 Selecting Data for a Report
- 4 Customizing a Report
- Defining the Layout
- Specifying the Items in a Detail Line
- Naming Select List and Detail Line Items
- Organizing Rows Into Break Groups
- Labeling Information
- Formatting Data Values
- Formatting Dates and Times
- Using TACL to Pass Parameters
- Conditional Printing of Items or Line Entries
- Redefining Special Characters
- Calculating Totals
- Calculating Subtotals
- Printing Double-Byte Characters
- A Comparison of the Report Writer and the Enform Language
- Index
Customizing a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
4-22
Labeling Information
Footings
A report can contain three types of footings:
•
A page footing appears at the bottom of each page of a report.
•
A report footing precedes the page footing on the last page of the report.
•
A break footing follows the break group for which it is defined.
Page and Report Footings
The following commands produce a page and report footing:
S> REPORT FOOTING "End of Summary" CENTER;
S> PAGE FOOTING TAB 50, "Page ", PAGE_NUMBER AS I2 ;
The right margin is 65. The report footing is centered. Footings on the last page appear
as shown in Figure 4-10
.
Figure 4-9. Example of Break Titles
Part No. Quantity
Customer No. 21
CENTRAL UNIVERSITY
Order No. 200320
5504
6201
6301
6400
5
16
6
7
CUSTNUM
Break Title
CUSTNUM
Break Title
Customer No. 123
BROWN MEDICAL CO
Order No. 200490
Order No. 300380
3210
5505
244
2402
1
1
6
12
VST0409.vsd