SQL/MX Report Writer Guide

ManualsBrandsHP ManualsServerHP NonStop G-Series

101

102

103

104

105

106

107

108

109

110

Customizing a Report

HP NonStop SQL/MX Report Writer Guide—527194-002

4-17

Labeling Information

•

You can specify a break column that is not in the detail line. The break occurs, but

the item is not printed. For example, you might want to print the break column

value in the break title but not in the detail line.

•

If the break column is an item in the detail line:

SUPPRESS ensures that the column value appears only in the first row of the

group. If a page break occurs in the middle of the group, the value appears

again in the first row of the new page.

NOSUPPRESS means that the column value appears in each detail line of the

group

Labeling Information

A report can contain various types of labels: column headings, titles, footings, line

numbers, and text inserted between print items in an output line.

Specifying Column Headings

•

You can choose default column headings or customized column headings in a

report.

•

For the default report format, the headings are:

For a print item that is a column of a table or view: the heading that was

specified when the table or view was created or altered.

If no heading was specified, the default heading is the column name.

The default heading for a print item that is an expression is (EXPR).

String literals and print items defined with an IF/THEN/ELSE clause or a

CONCAT clause do not have default headings.

•

You can suppress all headings in the report by setting the HEADINGS style option

OFF. After you set HEADINGS OFF, all headings are suppressed in the reports you

produce until you set HEADINGS ON, or you end your MXCI session.

•

You can use a DETAIL command to specify your own headings or specify that a

print item has no heading.

Headings for Column Identifier Print Items

The report writer uses heading information in the following order of precedence to