SQL/MP Report Writer Guide

Contents
HP NonStop SQL/MP Report Writer Guide—527213-001
ii
4. Customizing a Report
Using Views 3-26
Using Subqueries 3-28
Developing Multistep Queries 3-32
4. Customizing a Report
Defining the Layout 4-1
Specifying the Items in a Detail Line 4-11
Naming Select List and Detail Line Items 4-13
Organizing Rows Into Break Groups 4-14
Labeling Information 4-16
Formatting Data Values 4-28
Formatting Dates and Times 4-39
Using TACL to Pass Parameters 4-44
Conditional Printing of Items or Line Entries 4-46
Redefining Special Characters 4-47
Calculating Totals 4-48
Calculating Subtotals 4-51
Printing Double-Byte Characters 4-58
A. Comparison of the Report Writer and the Enform Language
Index
Figures
Figure i. NonStop SQL/MP Library Map ix
Figure 1-1. Sample Content of Tables 1-2
Figure 1-2. Example of Default Report Layout 1-5
Figure 1-3. A Sample Formatted Report 1-8
Figure 1-4.
Example of a Formatted Report 1-9
Figure 1-5.
Example of a Formatted Report 1-10
Figure 2-1. Setting Up Your Session Environment 2-2
Figure 2-2. Setting and Displaying Options 2-4
Figure 2-3. Example of Listing Rows 2-5
Figure 2-4. Defining a Window for Report Output 2-7
Figure 2-5. Defining a Window for Report Output 2-7
Figure 2-6. Defining a Window for Report Output 2-8
Figure 2-7. Relation of Window to Output Line 2-9
Figure 2-8. Example of Report Formatting Commands 2-10
Figure 2-9. Example of Repeating Stored Commands 2-15
Figure 2-10. Modifying OBEY Commands 2-19