SQL/MX Report Writer Guide

Introduction to the NonStop SQL/MX Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
1-15
Report Formatting Command Clauses
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
Style Options
Style options control the appearance of print items in a report. The style options are
summarized in Table 1-3.
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
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
SKIP Advance a specific number of lines before printing the next print
item
SPACE Number of blanks to print before the next print item
TAB Print position of the next print item
Note. For detailed descriptions of the NEED, PAGE, SKIP, SPACE, and TAB clauses, see the
DETAIL command in the SQL/MX Reference Manual.
Table 1-3. Style Options (page 1 of 2)
Style Option Default What the Option Defines
DATE_FORMAT M2/D2/Y2 Default format for date values
DECIMAL_POINT Period (.) Single-byte symbol for decimal point
HEADINGS ON Whether headings are generated
Table 1-1. Report Formatting Commands (page 2 of 2)
Command What the Command Defines