SQL/MX 3.2 Report Writer Guide (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Report Writer Guide—691130-001
iii
4. Customizing a Report
Using Subqueries 3-28
Developing Multistep Queries 3-32
Multilevel Group Aggregates 3-33
Conditional Aggregates 3-34
Row Value as Percent of All Row Values 3-35
4. Customizing a Report
Defining the Layout 4-2
Setting Margins 4-2
Paginating 4-6
Spacing Items and Lines
4-10
Specifying the Items in a Detail Line
4-12
Naming Select List and Detail Line Items 4-14
Organizing Rows Into Break Groups 4-15
Labeling Information 4-17
Specifying Column Headings 4-17
Headings for Column Identifier Print Items 4-17
Multiple-Line Headings 4-19
Specifying Titles 4-20
Page and Report Titles 4-20
Break Titles 4-22
Specifying Footings 4-24
Page and Report Footings 4-24
Break Footings 4-26
Line Numbers 4-27
Text Inserted Into a Line
4-30
Formatting Data Values 4-30
Using the AS Clause to Modify the Default Report Format
4-32
Display Format Specifications
4-32
Numeric Values
4-34
Monetary Values 4-35
Suppressing Leading or Trailing Zeros
4-38
Concatenating Text
4-39
Truncated Values 4-40
Filler Characters 4-40
Formatting Dates and Times
4-42
Date and Time Values
4-42
Julian Timestamp Formats 4-43
SQL/MX Date and Time Formats 4-44