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

About This Manual
HP NonStop SQL/MP Report Writer Guide—527213-001
viii
Related Manuals
Related Manuals
This manual is part of the NonStop SQL library of manuals (as shown in Figure i). The
library includes the following manuals:
•
Introduction to NonStop SQL provides an overview of the SQL/MP relational
database management system.
•
SQL Quick Start describes how to run SQLCI, how to execute simple queries on a
database, how to modify data, and how to produce a formatted report.
•
SQL/MP Installation and Management Manual explains how to plan, install, create,
and manage a NonStop SQL database; describes the syntax of installation and
management commands; and describes NonStop SQL catalogs and file structures.
•
SQL/MP Query Guide describes how to retrieve and modify data in a SQL/MP
database and how to analyze and improve query performance.
•
SQL/MP Version Management Guide describes the rules governing version
management for the NonStop SQL software, catalogs, objects, messages,
programs, and data structures.
•
SQL/MP Programming Manual for C and COBOL85 and the SQL Programming
Manual for Pascal and TAL describe the programmatic interface for the particular
language.
•
SQL/MP Reference Manual describes the SQL language elements, expressions,
functions, and statements. (See this manual for the complete description and
syntax of the report writer commands and the SELECT statement.)
•
SQL/MP Messages Manual describes NonStop SQL/MP messages for the
conversational interface, the application programming interface, and utilities.