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
Comparison of the Report Writer and the Enform
Language
HP NonStop SQL/MP Report Writer Guide—527213-001
A-4
BEFORE CHANGE BREAK FOOTING command
BY and BY DESC SELECT..GROUP BY..ORDER BY.. and BREAK ON
command
CENTER Only for column headings, titles, (1) footings, and the whole
report body
CUM and CUM OVER (1)
FOOTING PAGE FOOTING command
FORM PAGE and NEED clauses of print-item
HEADING HEADING clause in DETAIL line
INTERNAL JULIAN-DATE (1)
NOHEAD NOHEAD clause in DETAIL line
NOHEAD ALL HEADINGS style option OFF
NOPRINT IF/THEN/ELSE or AS clause or item omitted from DETAIL
command but included in ORDER BY clause
NOPRINT ALL DETAIL
PCT ‘Multistep queries
PCT OVER Multistep queries
SKIP SKIP clause of print-item
SPACE SPACE clause of print-item
SUBFOOTING (1)
SUBTITLE (1)
SUBTOTAL SUBTOTAL command (based on BREAK command)
SUPPRESS IF/THEN/ELSE clause of DETAIL command
TAB TAB clause of print-item
TIMESTAMP-DATE AS DATE/TIME clause
TIMESTAMP-TIME
TITLE PAGE TITLE command (no default)
TOTAL TOTAL command
WHERE SELECT command WHERE clause
(1) No comparable feature
Table A-2. Enform Clauses (page 2 of 2)
Enform Clauses SQLCI With Report Writer