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-4
Defining the Layout
4 blank lines appear here. )
Summary of Employees
CUSTNUM CUSTNAME
------- --------
The first blank line is the default top margin. The next three blank lines are the
specified skips. The blank line following the title is the default skip that always follows
the title line.
You use the same technique for bottom margins, except SKIP follows the footing text if
specified. In the next example, the page footing is positioned above a bottom margin of
3 lines (2 lines specified by SKIP 2 and 1 line, which is the default bottom margin):
S> PAGE FOOTING "Page ", PAGE_NUMBER AS I2 , SKIP 2;
.
.
Page 1
( New page starts here. )
For more information about these commands, see Titles on page 4-18 and Footings on
page 4-22.
Paginating
The following report writer features control where page breaks occur in a report: