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-53
Calculating Subtotals
Figure 4-20. Example of Report With Subtotals (Page 1 of 2)
Supplier Parts Summary
Date: April 20, 1987
Time: 02:06:56 PM
Part
Number
Available
Units
Unit Cost
(dollars)
Total Cost
(dollars)
Estimated Profit
Supplier :
1
NEW COMPUTERS INC,
SAN
FRANCISCO,
CALIFORNIA
212
244
3525
2002
2001
255
4426
3321
2100
3220
2000.00
2400.00
3300.00
700.00
1000.00
7050000.00
10622400.00
10959300.00
1470000.00
3220000.00
1762500.00
2655600.00
2324700.00
840000.00
1610000.00
6400
6301 2331
1268
23327301
150.00
390.00
300.00
349650.00
494520.00
699600.00
55459235.00
221445.00
202880.00
291500.00
19290545.00
.
.
.
.
.
.
.
.
.
.
244
2003
2001
5110
6401
5504
6500
2100
4426
6603
Supplier
:
2
DATA TERMINAL INC,
LAS VEGAS,
NEVADA
2200
3236
1308
2630
2532
430
2200.00
750.00
1400.00
350.00
85.00
500.00
60.00
25.00
9737200.00
1575000.00
3080000.00
1132600.00
223550.00
654000.00
151920.00
10750.00
3540800.00
735000.00
1320000.00
566300.00
210400.00
294300.00
88620.00
8600.00
55459235.00
19290545.00
Page 1
Supplier
:
3
HIGH DENSITY INC,
NEW YORK,
NEW YORK
6401
255
212
6500
3525
3321
1308
2532
1900.00
3000.00
480.00
65.00
6697500.00
9963000.00
627840.00
164580.00
2115000.00
3321000.00
320460.00
75960.00
17452920.00
5832420.00
VST0420.vsd