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-27
Labeling Information
If you change the previous DETAIL command to specify LINE_NUMBER OVER
PARTNUM AS I4, the line number is reset at the beginning of each break group as
shown in Figure 4-14
.
Figure 4-13. Example of Numbering Lines
Figure 4-14. Example of Numbering Break Group Lines
Parts Supplier List
Page 1
Part 212
Part 244
Part 255
1
2
Part Cost
Supplier
Part Cost
Supplier
Part Cost
Supplier
Part Cost
Supplier
3
4
5
Part Cost
Supplier
2000.00
1900.00
2400.00
2200.00
3300.00
1 NEW COMPUTERS INC
3 HIGH DENSITY INC
1 NEW COMPUTERS INC
1 DATA TERMINAL INC
1 NEW COMPUTERS INC
VST0413.vsd
Parts Supplier List
Page 1
Part 212
Part 244
Part 255
1
2
Part Cost
Supplier
Part Cost
Supplier
Part Cost
Supplier
Part Cost
Supplier
1
2
1
Part Cost
Supplier
2000.00
1900.00
2400.00
2200.00
3300.00
1 NEW COMPUTERS INC
3 HIGH DENSITY INC
1 NEW COMPUTERS INC
1 DATA TERMINAL INC
1 NEW COMPUTERS INC
VST0414.vsd