SQL/MP Report Writer Guide

Customizing a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
4-65
Printing Double-Byte Characters
Displaying Subtotal Labels With Double-Byte Characters
To identify the break group to which a subtotal corresponds, the report writer prints a
subtotal label under the break column. The SUBTOTAL_LABEL option of the SET
STYLE command specifies a label for the report writer to print in the break column on
the same line as a subtotal. Only one subtotal label can be defined at a time, and the
report writer uses that label for all break groups.
When printing subtotal labels with double-byte characters, there are two conditions in
which double-byte characters can be split:
•
Different break and subtotal column
•
Same break and subtotal column
To correct reports that are splitting characters in subtotal labels, you can use either an
even-numbered “I” display descriptor, or a correctly-sized “I” display descriptor.
Using Different Break and Subtotal Columns
In cases where the subtotal column is not the same as the break column, and the
subtotal label does not fit within the width of the break column, the subtotal label is
truncated. The truncation can split a double-byte character.
Figure 4-30
shows an example of what can happen when the subtotal and break
columns are different, and data truncation occurs on a field containing double-byte
characters.
Figure 4-29. Splitting Double-Byte Characters With the TAB Clause
VST0429.vsd
>>SET LIST_COUNT 0;
>>SELECT * FROM PERSNL.DEPT;
S>DETAIL _KANJI"c1c2c3c4c5c6c7", TAB 8, DEPTNAME;
S>L F 7;
S>
TAB 8
DEPTNAME
c1c2c3#@INANCE
c1c2c3@#ERSONNEL
c1c2c3@@NVENTORY
c1c2c3c@HIPPING
c1c2c3@#ARKETING
c1c2c3##ANADA SALES
c1c2c3#@ERMNY SALES