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-3
Defining the Layout
The default top and bottom margins are one line each. You can increase the apparent
size of these margins with a PAGE TITLE or PAGE FOOTING command. If you have
no title, specify PAGE TITLE "" for a top margin of 3 lines or specify
PAGE TITLE
SKIP desired-margin-size - 3 for more than 3 lines.
For example, the following command produces a margin size of 4 blank lines
preceding the headings (SKIP 4 - 3 = SKIP 1):
S> PAGE TITLE SKIP 1;
( 4 blank lines appear here. )
CUSTNUM CUSTNAME
------- --------
The first blank line is the default top margin. The second blank line is the specified
skip. The third blank line is the default skip for the title line. The fourth blank line is the
default skip following the title line.
If you specify text in the title line, specify
PAGE TITLE SKIP desired-margin-
size - 1, " text". For example, the following command produces a desired
margin size of 4 lines (SKIP 4 - 1 = SKIP 3):
S> PAGE TITLE SKIP 3, "Summary of Employees"; (
Figure 4-2. Default Margin Settings - Printer Report
Printed Report
Left Margin 0
Print Position 1
Right Margin At
Output Device Width
VST0402.vsd