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
HP NonStop SQL/MP Report Writer Guide—527213-001
vii
About This Manual
This manual provides task-oriented instructions on how to design and produce reports
using the report writer and information from a NonStop SQL/MP database. The manual
also provides an overview of the report writer commands and SQLCI commands that
are directly related to formatting reports.
Audience
Readers should have some experience in using command interpreters and be familiar
with the HP NonStop Kernel operating system. If you are not a programmer, you might
need to request a programmer's assistance in creating reports that require the use of
the more advanced features.
As a reader of this manual, you should have read the Introduction to NonStop SQL so
that you are familiar with the terminology. You can also read the NonStop SQL Quick
Start for a quick introduction to expressing ad hoc queries and producing simple
reports.
How to Use This Manual
This manual is organized to make instructions for specific report writing tasks easy to
find:
The version of SQL implemented by HP and referred to in this manual conforms with
the ANSI SQL standard; minor exceptions are noted in the SQL/MP Reference
Manual, which fully documents the HP implementation of SQL.
Section 1,
Introduction to the
NonStop SQL/MP
Report Writer
introduces the report writer, describes its components, and
compares the default report format with a custom formatted
report
Section 2, Using
SQLCI and the
Report Writer
gives instructions for running SQLCI and using report writer
commands. This section describes various ways to define and
produce reports
Section 3, Selecting
Data for a Report
shows you how to develop queries and specify calculations to
process the source data for a report
Section 4,
Customizing a
Report
gives instructions for defining the report layout and style. You
can give detailed specifications for output lines, line items,
column headings, titles, and footings
Section A,
Comparison of the
Report Writer and the
Enform Language
lists the SQLCI and report writer features that correspond to
features of the Enform language