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-8
Defining the Layout
Spacing Items and Lines
The following report writer features control spacing of print items and lines:
Figure 4-4. Result of Using the NEED Clause
1
2
3
4
5
6
7
8
9
10
11
12
13
14
1
2
3
4
5
6
7
8
9
10
Supplier No. 8
ATTRACTIVE CORP
7777 FOUNTAIN WAY
CHICAGO, ILLINOIS 60610
Supplier No. 2
DATA TERMINAL INC
2000 BAKER STREET
LAS VEGAS, NEVADA 66134
Supplier No. 15
DATADRIVE CORP
100 MAC ARTHUR
DALLAS, TEXAS 75244
Supplier No. 3
HIGH DENSITY INC
7600 EMERSON
NEW YORK, NEW YORK 10230
S >
VST0402.vsd