SQL/MX Report Writer Guide

Customizing a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
4-30
Text Inserted Into a Line
Text Inserted Into a Line
You can insert text into a detail line, title, or footing by specifying a string literal as a
print item. Figure 4-13 illustrates this technique. You can use the technique to create
these effects:
•
Insert commas between concatenated items.
•
Insert descriptions of an item that precedes or follows the string literal. For
example, the DETAIL, BREAK TITLE, and TITLE commands in the preceding
report definition include descriptive string literals.
You can also insert text in a line with AS clause decorations. For more information, see
Using Decorations in Display Formats on page 4-36 and Filler Characters on
page 4-40.
Formatting Data Values
You can use the AS clause to specify a display format for a print item that is a column
identifier, literal, arithmetic expression, or CONCAT clause. If you do not specify an AS
clause, or if you use the default report definition to display your data, the report writer
uses the default display formats listed in Table 4-1.
Figure 4-14. Numbering Break Group Lines
Parts Supplier List
Page 1
Part 212
Part 244
Part 255
1
2
Part Cost
Supplier
Part Cost
Supplier
Part Cost
Supplier
Part Cost
Supplier
1
2
1
Part Cost
Supplier
2000.00
1900.00
2400.00
2200.00
3300.00
1 NEW COMPUTERS INC
3 HIGH DENSITY INC
1 NEW COMPUTERS INC
1 DATA TERMINAL INC
1 NEW COMPUTERS INC
VST0414.vsd