Report Options |
A number of options effect reports created using the OLAP DML. These options are listed in Table: Report Options.
Report Options
| Statement | Description |
|---|---|
| BMARGIN
|
An option that specifies the number of blank lines for the bottom margin of output pages. |
| COLWIDTH
|
An option that controls the default width of data columns in report output. |
| COMMAS
|
An option that controls the use of a character to separate thousands and millions in numeric output. |
| DECIMALCHAR
|
(Read-only) An option that records the character that is used as the decimal marker in output. |
| DECIMALS
|
An option that controls the number of decimal places that are shown in numeric output. |
| LCOLWIDTH
|
An option that controls the default width of the label column in reports. |
| LINENUM
|
An option that contains the current line number of the output. |
| LINESLEFT
|
(Read-only) An option that contains the number of lines left on the current page. |
| LSIZE
|
An option that specifies the line size within which the STDHDR program centers the standard header. |
| NASPELL
|
An option that controls the spelling that is used for NA values in output. |
| NOSPELL
|
(Read-only) An option that contains the text that is used for FALSE Boolean values in the output of OLAP DML statements. |
| PAGENUM
|
An option that contains the current page number of output. |
| PAGEPRG
|
An option that contains the name of a program or the text of a statement to be executed at the beginning of each page of output. |
| PAGESIZE
|
An option that contains the size of a page of output. |
| PAGING
|
An option that controls the production of paged output in Oracle OLAP. |
| PARENS
|
An option that controls whether negative numbers are represented in output with parentheses or a minus sign. |
| THOUSANDSCHAR
|
(Read-only) An option that contains the character that is used as the thousands group marker in output. |
| TMARGIN
|
An option that defines the number of blank lines for the top margin of output pages, above the running page heading when PAGING is set to YES. |
| YESSPELL
|
(Read-only) An option that specifies the text that is used for TRUE Boolean values in the output of OLAP DML statements. |
| ZEROROW
|
An option that controls suppresses report rows with numeric values that are all NAs or all zeros or would be represented as zeros. |
| ZSPELL
|
An option that specifies the default text that is used for representing numeric zero values in output produced by the HEADING, REPORT, and ROW commands. |