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-67
Printing Double-Byte Characters
Using Even-Numbered Display Descriptors for Subtotal Column Labels
Figure 4-32 demonstrates how to use an even-numbered “I” display descriptor to
format a report. In this example, the break column is different from the subtotal column,
but you can use the same techniques as in the previous scenario (where the break
column is the same as the subtotal column).
The addition of the I8 display descriptor adjusts the DEPTNUM column so that it
occupies eight print positions (an even number) instead of seven.
Figure 4-31. Splitting Characters With Same Break and Subtotal Columns
VST0431.vsd
S>DETAIL TAB 20, SALARY HEADING "This is SALARY heading";
Subtotal Lable
This is SALARY heading
>>SET SUBTOTAL_LABEL _KANJI"c1c2c3c4c5c6";
c1c2c3c4c5@
c1c2c3c4c5#
Subtotal
Strings
Truncated With
Garbled
Characters
175500.00
175500.00
137000.10
137000.10
136000.00
>>SET LIST_COUNT 0;
>>SELECT * FROM PERSNL.EMPLOYEE;
S>L F 3;
S>BREAK ON SALARY;
S>SUBTOTAL SALARY
BREAK and
SUBTOTAL
are defined
for the same
column
11 print
positions are
reserved for
the salary
value