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

Index
HP NonStop SQL/MP Report Writer Guide—527213-001
Index-4
G
Formatting commands (continued)
summary of 1-12
Format, data 4-28
FROM clause 3-3
Functions, summary of report 1-14
G
GROUP BY clause
computing sums or averages with 3-17
select list relation 3-16
Grouping columns
choosing 3-20
select list relation 3-16
Guardian timestamp
See Julian timestamp
H
Headings
suppressing 4-16
I
I display descriptor
using 4-32
with double-byte characters 4-68
zero suppression with 4-35
IF/THEN/ELSE clause
subtotaling, substitute method 4-56
using 4-46
Implicit correlation name 3-4, 3-30
IN predicate 3-9
INLINE facility, TACL 4-45
Integer display 4-30
INTERVAL data type, totaling 4-51
Invoice example 3-28
INVOKE command 3-2
Items
naming 4-13
spacing of 4-1
J
Joining tables 3-9
Julian timestamp 4-40
JULIANTIMESTAMP function 4-42
Justification of values 4-29
K
Kanji character set 4-59
Korean character set 4-58
L
Labeling information 4-1
Language, displaying current 2-3
Layout options
summary of 1-13
using 4-1
Leading zeros 4-1
LEFT_MARGIN layout option 4-59
Length
of line 4-20
of page 1-6, 4-5
LIKE predicate
comparison operators 3-7
using 3-11
Lines
folding 2-6
, 4-59
heading 4-18
inserting text in 4-28
keeping together on page 4-5
logical 1-11
maximum length 1-13
numbering 4-25
spacing of 4-8
wrapping text 2-7
LINE_NUMBER function 4-25
LINE_SPACING layout option 4-9
LIST command
ALL parameter 4-5
using 2-5