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-68
Printing Double-Byte Characters
Using Correctly-Sized “I” Display Descriptors With Subtotal Column
Labels
Figure 4-33 demonstrates how to use the “I” display descriptor with a number that is
larger than the column in order to accommodate the entire subtotal string.
The addition of the I12 display descriptor adjusts the DEPTNUM column so that it
occupies twelve print positions (an even number) instead of seven.
Figure 4-32. Using an Even-Numbered Display Descriptor for Subtotal Labels
VST0432.vsd
DEPTNUM
9000
c1c2c3c4
1000
c1c2c3c4
3000
SALARY
175500.00
175500.00
137000.10
137000.10
136000.00
S>
S>DETAIL DEPTNUM AS I8, SALARY;
>>SET SUBTOTAL_LABEL _KANJI"c1c2c3c4c5c6";
>>SET LIST_COUNT 0;
>>SELECT * FROM PERSNL.EMPLOYEE;
S>L F 3;
S>BREAK ON DEPTNUM;
S>SUBTOTAL SALARY;
S>
S>