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
Introduction to the NonStop SQL/MP Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
1-9
Report Layout and Style
7. Break footing
8. Total lines
9. Report footing
10. Page footing
11. Report Layout and Style
Figure 1-4. Example of a Formatted Report
Summary of Orders 09/25/94 (1)
Report Author and Version: Tom Jones, v. 2
(2)
Part No.
Unit Price Total Price Order No.
(3)
PC SILVER, 20 MB
2450.00
212
2500.00
29400.00
20000.00
49400.00
400410
500450
(4)
(5)
(6)
*
Suggested Price:
2500.00
(7)
PC GOLD, 30 MB
244
3500.00
3500.00
3500.00
2800.00
3000.00
3000.00
10500.00
14000.00
18000.00
144500.00
18000.00
56000.00
28000.00
100210
100250
300350
300380
800660
200300
*
Suggested Price:
3000.00
PC DIAMOND, 60 MB
255
3900.00
3800.00
3900.00
4000.00
39000.00
45600.00
147400.00
16000.00
46800.00
101220
400410
700510
500450
*
Suggested Price:
4000.00
Page 1 (10)
VST0103.vsd