SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-6
REPORT TITLE Command
REPORT TITLE Command
REPORT TITLE is an SQLCI report writer command that specifies text to print at the
beginning of the report as the main title for the report.
print-item
specifies an item to print in the report title. The form for print-item is the same
as for the DETAIL command, except that it cannot include the HEADING,
NOHEAD, or NAME clause. For more information, see DETAIL Command on
page D-47.
If you specify a column for print-item, SQL uses the column value from the first
detail line in the report.
CENTER
centers each line of the report title between the left and right margins. If you omit
CENTER, the report title starts immediately after the left margin.
Considerations—REPORT TITLE

A blank line separates the report title from the body of the report. The report title
appears below the page title on the first page.

Each REPORT TITLE command replaces the previous one. Only one REPORT
TITLE command is in effect at a time. When you enter a REPORT TITLE
command, it replaces the previous REPORT TITLE command.

The print list is limited to 4072 bytes of printed output. The output of a REPORT
TITLE command is a logical line, although (depending on margin settings, device
widths, and use of the SKIP clause) it might print on more than one physical line. A
logical line is limited to 4072 bytes, including the field widths of all print items and
the number of spaces between items.
Examples—REPORT TITLE

This example selects data for a report and define list count:
>> SET LIST_COUNT 0;
>> SELECT * FROM SALES.ORDERS, PERSNL.EMPLOYEE
+> WHERE SALESREP = EMPNUM AND
+> SALESREP = 226;

This example defines a report title, defines a detail line that omits the SALESREP
column, and lists all selected rows. Other elements of the report use the default
report format.
REPORT TITLE print-item [,print-item]...[ CENTER ] ;