A.18 Reporting Statements

Table A-29, "Reporting Statements" lists the OLAP DML statements that you use to create simple reports.

Table A-29 Reporting Statements

Statement	Description
BLANK	Sends one or more blank lines to the current outfile.
COLVAL	Within a ROW command, ROW function, or REPORT command, returns a numeric value from a column to the left of the current column in the same row of a report.
HEADING	Produces titles and column headings for a report.
PAGE	Forces a page break in output when PAGING is set to YES.
REPORT	Produces output for one or more data expressions.
ROW command	Produces a line of data in cells, one after another in a single row.
ROW function	Returns a line of data in cells, one after another in a single row.
RUNTOTAL	Within a ROW command, ROW function, or REPORT command, returns the running total of an expression.
SHOW	Displays a single value of an expression.
STDHDR	Generates the standard Oracle OLAP heading at the top of every page of report output.
SUBTOTAL	Within a ROW command, ROW function, or REPORT command, returns the value of one of the subtotals accumulated in a report.
ZEROTOTAL	Within a ROW command, ROW function, or REPORT command, resets one or all subtotals of specified report columns to zero.