SQL/MX Report Writer Guide

HP NonStop SQL/MX Report Writer Guide—527194-002
ix
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/MX database. The manual
also provides an overview of the report writer commands and MXCI 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 programming assistance to create reports using advanced features.
Further Reading
Read the SQL/MX 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/MX Reference
Manual, which fully documents the HP implementation of SQL.
Section 1,
Introduction to the
NonStop SQL/MX
Report Writer
Introduces the report writer, describes its components, and
compares the default report format with a custom formatted
report.
Section 2, Using
MXCI and the Report
Writer
Gives instructions for running MXCI and using report writer
commands. You can define and produce reports in various
ways.
Section 3, Selecting
Data for a Report
Shows 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, Migration
from SQL/MP Report
Writer to SQL/MX
Report Writer
Lists the SQL/MX report writer features that are different from
SQL/MP report writer.