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-61
Printing Double-Byte Characters
Using the TAB Clause to Adjust Display Columns
Another way to adjust a report so that double-byte characters are not split with text
wrapping or folding is to use the TAB clause.
Figure 4-26
demonstrates changing the TAB clause specification from 40 to 41 to
adjust the detail line so that double-byte characters are not split if text wrapping occurs.
Figure 4-25. Using the SPACE Clause to Adjust Display Columns
VST0425.vsd
>>SET LIST_COUNT 0;
>>SELECT
* FROM PERSNL.DEPT;
>>S
S>SET RIGHT_MARGIN 55;
S>DETAIL col1, col2, tab 30, col3, tab 40 col4,
+>SPACE 1, col5;
S>L F 3;
TAB 30
TAB 40
1 spaces
DEPTNUM DEPTNAME MANAGER RPTDEPT LOCATION
1000
1500
FINANCE
PERSONNEL
INVENTORY2000
23
213
32
9000
1000
9000
c1c2
c1c2c3c4C5
c1c2c3c4c5c6c7
>>S