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
Comparison of the Report Writer and the Enform
Language
HP NonStop SQL/MP Report Writer Guide—527213-001
A-7
Note that some aggregate functions are available within the SELECT command select
list for grouped values. There are no user or target aggregates. Although SQLCI and
the report writer do not directly provide the capability of multilevel group aggregates or
conditional aggregates, you can perform these operations using multistep queries. For
more information on examples of performing these operations in SQLCI, see
Developing Multistep Queries
on page 3-32.
In SQLCI, user-defined parameters are not allowed in report formatting commands.