Reporting Statements |
Table: Reporting Statements lists the OLAP DML statements that you use to create simple reports.
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. |