SQL/MP Report Writer Guide

Customizing a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
4-66
Printing Double-Byte Characters
Using the Same Break and Subtotal Columns
In cases where the subtotal column is the same as the break column, the subtotal label
and the subtotal value both print under that one column. If the column width is large
enough to accommodate both the label and the value, both are printed; otherwise, the
label is truncated and can be entirely overwritten by the subtotal value. When the
subtotal label is not entirely overwritten, but truncated, character splitting can occur.
Figure 4-31
shows an example of this condition.
Suppose for this example that the SALARY column requires that 11 print positions be
reserved for displaying values, as defined by the following:
salary numeric (8,2) unsigned
Figure 4-30. Splitting Characters With Different Break and Subtotal Columns
VST0430.vsd
DEPTNUM
9000
c1c2c3@
1000
c1c2c3@
3000
>>SET LIST_COUNT 0;
>>SET SUBTOTAL_LABEL _KANJI"c1c2c3c4c5c6";
>>SELECT * FROM PERSNL.EMPLOYEE;
S>DETAIL TAB 20, DEPTNUM, SALARY;
S>BREAK ON DEPTNUM;
S>SUBTOTAL SALARY;
S>L F 3;
Break and
Subtotal
Defined on
Different
Columns
Subtotal Lable
Break Column
Width = 7
Subtotal
Strings are
Truncated
With Garbled
Characters
SALARY
175500.00
175500.00
137000.10
137000.10
136000.00