SQL/MX Report Writer Guide

Contents
HP NonStop SQL/MX Report Writer Guide—527194-002
iii
4. Customizing a Report
Preparing a SELECT Command 3-25
Using Views 3-26
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