SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-52
SHOW REPORT Command
SHOW REPORT Command
SHOW REPORT is an SQLCI report writer command that displays the current
SELECT statement and the current report formatting commands.
* displays the SELECT and all report formatting commands.
For information about a specific command, see the entry for that command. (The
command listed as BREAK refers to the BREAK ON command.)
Example—SHOW REPORT
This example displays the current report title and page footer:
>> SHOW REPORT TITLE, PAGE FOOTING;
REPORT TITLE "ORDER DETAILS" CENTER;
PAGE FOOTING TAB 50, "Page ", PAGE_NUMBER AS I3;
SHOW REPORT { { command } [, command ] ... } ;
{ * }
command is:
{ BREAK }
{ BREAK FOOTING }
{ BREAK TITLE }
{ DETAIL }
{ NAME }
{ PAGE FOOTING }
{ PAGE TITLE }
{ REPORT FOOTING }
{ REPORT TITLE }
{ SELECT }
{ SUBTOTAL }
{ TOTAL }