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-10
Report Writer Components
Report Writer Components
In addition to SQLCI commands that are useful when generating reports, the report
writer has the following components:
•
Print items and logical lines
•
Report formatting commands
Figure 1-5. Example of a Formatted Report
Suggested Price:
VST0104.vsd
Page 2
(10)
END OF SUMMARY
(9)
(8)
390490.00
SMART MODEM, 2400
7301
425.00
415.00
425.00
425.00
3400.00
14940.00
40440.00
5100.00
17000.00
101220
400410
800660
600480
*
Suggested Price:
425.00
SMART MODEM, 1200
7102
275.00
275.00
275.00
1925.00
1375.00
4950.00
1650.00
101220
700510
800660
*
Suggested Price:
275.00
DISK CONTROLLER
95.00
6500
95.00
950.00
760.00
3800.00
100250
700510
*
95.00
95.00 2090.00 800660
Summary of Orders 09/25/94 (1)
Part No.
Unit Price Total Price Order No.
(3)