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
Selecting Data for a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
3-3
Developing a Query
The detail lines are to be ordered by supplier with a break on SUPPLIER.SUPPNUM,
SUPPLIER.SUPPNAME, SUPPLIER.CITY, and SUPPLIER.STATE. These values are
printed in the break title. No SELECT data is needed for the page footing or report
footing.
The FROM clause of the SELECT command specifies the names of all tables from
which the SELECT command retrieves data. For example, the following command
retrieves values from the PARTS table. An asterisk in the select list retrieves a value
Figure 3-1. Plan for Report Content
‘
VST0301.vsd
Supplier Parts Summary
Date:
date Time:
time
Part
Number
Available
Units
Unit Cost
(dollars)
Total Cost
(dollars)
Estimated
Profit
12
34
5
suppnum, suppname, city, state
nnnn
nnnn
.
.
nnnn
nnnn
nnnn
.
.
nnnn
nnnn.nn
nnnn.nn
.
.
nnnn.nn
nnnnnnn.nn
nnnnnnn.nn
nnnnnnn.nn
.
.
nnnnnnn.nn
nnnnnnn.nn
nnnnnnn.nn
.
.
nnnnnnnnn.nn nnnnnnnn.nn
suppnum, suppname, city, state
nnnn
nnnn
.
.
nnnn
nnnn
nnnn
.
.
nnnn
nnnn.nn
nnnn.nn
.
.
nnnn.nn
nnnnnnn.nn
nnnnnnn.nn
nnnnnnn.nn
.
.
nnnnnnnnn.nn
nnnnnnn.nn
nnnnnnn.nn
nnnnnnn.nn
.
.
nnnnnnnn.nn
.
.
.
.
.
.
.
.
.
.
nnnnnnnnn.nn
nnnnnnnnnnn.nn
nnnnnnnn.nn
nnnnnnnn.nn
End of Summary
Page nnn