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
Hewlett-Packard Company—527213-001
i
HP NonStop SQL/MP Report
Writer Guide
Index Figures Tables
What’s New in This Manual v
Manual Information v
New and Changed Information v
About This Manual vii
Audience vii
How to Use This Manual vii
Related Manuals viii
Notation Conventions x
1. Introduction to the NonStop SQL/MP Report Writer
Data Organization 1-1
SQL Database Reports 1-2
Report Development Steps 1-3
Report Layout and Style 1-4
Report Writer Components 1-10
2. Using SQLCI and the Report Writer
Starting and Ending an SQLCI Session 2-1
Setting Up Your Session Environment 2-1
Entering Report Formatting Commands
2-10
Specifying Output Files
2-12
Executing a Command Repeatedly 2-13
Defining Reports in Command Files 2-15
Using the Report Writer to Produce Text From Data 2-20
3. Selecting Data for a Report
Developing a Query 3-1
Grouping Data for Calculations
3-15
Selecting Distinct Rows
3-20
Using Expressions to Calculate Report Values 3-21
Using Parameters With SELECT Commands 3-23
Preparing a SELECT Command 3-24