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
Introduction to the NonStop SQL/MP Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
1-12
Report Writer Components
between items. For a print item formatted with the AS clause descriptor Cn.w, use w as
the field width. For example, if a VARCHAR column named JOBRESP is formatted
with AS C0.30, use 30 as the field width for that item.
Report Formatting Commands
Report formatting commands specify the content of detail lines, titles, footings, and
column headings. Report formatting commands can also calculate subtotals of values
in columns at specified break points, as well as calculate the total value of a column
over all rows in the report.
The report formatting commands are summarized in Table 1-1.
Report Formatting Command Clauses
Clauses in report formatting commands specify display formats for print items. The
report formatting command clauses are summarized in Table 1-2
Table 1-1. Report Formatting Commands
Command What the Command Defines
BREAK FOOTING Text to print at the end of a break group
BREAK ON The grouping of detail lines by column (print item) value
BREAK TITLE Text to print at the start of a break group
DETAIL Detail line content and format
NAME Name for a column in the select list (to be used in report
definition only)
PAGE FOOTING Text to print at the bottom of each page
PAGE TITLE Text to print at the top of each page
REPORT FOOTING Text to print at the end of the report
REPORT TITLE Text to print at the start of the report
SUBTOTAL Which items to subtotal and when to calculate the subtotal
TOTAL Which items to total
Table 1-2. Report Formatting Command Clauses (page 1 of 2)
Clause What the Clause Specifies
AS Display format for a print item
AS DATE/TIME Display format for a date, time, or date and time value
CONCAT Print one or more print items without intervening spaces
IF/THEN/ELSE Condition for printing items
NEED Number of lines required on a page to print the following print items
PAGE Advance to the next page and optionally start a new page-number
sequence