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-64
Printing Double-Byte Characters
In Figure 4-28, the display descriptor, A15, defines a width that is too small, which
truncates the display column in the middle of the eighth double-byte character. To
adjust for this condition, the display descriptor can be specified as A16.
Tabbing Backwards With Double-Byte Characters
When you tab backwards on a detail line using the TAB clause, you can cause data to
overlap previous data. If the data consists of double-byte characters, character splitting
can occur when overlapped with other data.
In the example shown in Figure 4-29
, the TAB 8 clause in the DETAIL command
causes the DEPTNAME to start printing in print position 8. This printing position splits
the fourth double-byte character (c4), causing it to appear incorrect. To adjust for this
condition, the TAB value can be set to either 7 or 9.
Figure 4-28. Splitting Double-Byte Characters With Incorrectly-Sized Display
Descriptors
VST0428.vsd
>>SET LIST_COUNT 0;
>>SELECT * FROM PERSNL.DEPT;
S>
S>
S>DETAIL DEPTNAME, LOCATION AS A15;
S>L F 3;
DEPTNAME
LOCATION
FINANCE c1c2c3c4c5c6c7#
PERSONNEL c0c9c8c7c6c5c4@
INVENTORY c1c3c5c7c9c0c8#
S>