SQL/MX Report Writer Guide

HP NonStop SQL/MX Report Writer Guide—527194-002
4-1
4 Customizing a Report
You can use report formatting commands and layout and style options to enhance a
report. Examples in this section show you how to produce the special effects you might
want in a report. These tasks are described:
•
Defining the layout by setting margins, paginating, and spacing items and lines
•
Organizing rows into break groups to emphasize sets and subsets of values and to
compute subtotals
•
Labeling information with column headings, titles, footings, line numbers, and
descriptive text
•
Formatting data such as numeric values, monetary values, names, dates and
times; suppressing leading and trailing zeros; truncating values; and replacing
blank print positions with filler characters
•
Specifying the items to be used in detail lines
•
Printing items or line entries conditionally
•
Redefining special characters such as the underline and decimal point
•
Calculating totals and subtotals
•
Printing double-byte characters
Setting Margins 4-2
Paginating 4-6
Spacing Items and Lines 4-10
Specifying the Items in a Detail Line 4-12
Naming Select List and Detail Line Items 4-14
Organizing Rows Into Break Groups 4-15
Specifying Column Headings 4-17
Specifying Titles 4-20
Specifying Footings 4-24
Formatting Data Values 4-30
Conditional Printing of Items or Line Entries 4-46
Redefining Special Characters 4-48
Calculating Totals 4-49
Printing Double-Byte Characters 4-58