SQL/MP Report Writer Guide

Customizing a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
4-36
Formatting Data Values
The I w[. m] display descriptor also suppresses leading zeros if you omit m. For
example, I8 does not print leading zeros but I8.6 does if the integer consists of fewer
than 6 digits.
In a mask, you can use the uppercase character Z to suppress leading and trailing
zeros.
You can use the BZ modifier to suppress all zeros when the value is zero: for example,
AS "[BZ] M<ZZZZ>". If you include a modifier, you must enclose the modifier and
display descriptor in quotation marks.
For information about replacing suppressed leading zeros with a character, see Filler
Characters on page 4-38.
You can also suppress trailing zeros by truncating the value.
Text Concatenation
The CONCAT clause is useful for formatting names of persons or places. You can
concatenate parts of names stored in separate columns of a table and insert
characters between the concatenated values.
In the EMPLOYEE table, FIRST_NAME and LAST_NAME are stored in separate
columns. You can define a print item of a detail line to concatenate the names in two
ways:
Descriptor Result
18 355
18.6 000355
Mask Value Result
M<ZZZ,ZZ9.9
9>
2.453 2.45
9023.00 9023.00
M<9,999> 5432 5,432
300 0,300
00,000
M<ZZZZ> 300 300
M<$ZZZ9.99> 5432 $5432.00
300.153 $ 300.15
0$ 0.00