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-69
Printing Double-Byte Characters
Figure 4-33. Using a Correctly-Sized Display Descriptor for Subtotal Column
Lables
VST0433.vsd
S>DETAIL DEPTNUM AS I12, JOBCODE, SALARY;
>>SET SUBTOTAL_LABEL _KANJI"c1c2c3c4c5c6";
>>SET LIST_COUNT 0;
>>SELECT * FROM PERSNL.EMPLOYEE;
S>L F 5;
S>BREAK ON DEPTNUM;
S>SUBTOTAL SALARY;
S>
S>
DEPTNUM
9000
c1c2c3c4c5c6
1000
c1c2c3c4c5c6
3000
SALARY
175500.00
175500.00
137000.10
137000.10
136000.00
S>
JOBCODE
100
100
100