Database Connection | Database connection name from which the row receives data. |
Row Height / Column Width | Height for the selected rows, or width for the selected columns. |
Hide Always | Hide the row or column when the report is viewed and in the printed output. The row is displayed only in the Report Designer. |
Suppression Ignores Row / Column | Ignore the data in the hidden rows / columns, select this option. When evaluating suppression, no cells in the hidden rows / columns are evaluated. Include the data in the hidden rows / columns, deselect this option. When evaluating suppression, all cells in the hidden rows / columns that contain data are evaluated. Note: You can evaluate suppression based on hidden cells when you specifically reference the cells by using the Advanced Options method for conditional suppression.
|
Suppression | Select None, Show Always to turn suppression off. This is the default setting. Select Basic Options to suppress data based on any of the following methods: Select If Zero, Suppress to suppress all values that equal zero. If all data values in a given row or column equal zero, the entire row or column is suppressed. Select If Missing, Suppress to suppress all cells that do not contain data. If all cells in a given row or column do not contain data, the entire row or column is suppressed. Select If Error, Suppress to suppress data in cells that cannot be retrieved or calculated because of errors. If all data values contain errors in a given row or column, the entire row or column is suppressed.
Select Advanced Options to suppress data based on specific criteria, then select Setup to define your criteria. |
Heading - Suppress Repeats | Suppresses repeated row or column headings in the grid. When selected, the system shows one column or row heading across multiple columns and rows. When deselected, the column or row heading is repeated in each column or row. |
Suppress Trailing Dots | Toggles whether trailing dots are displayed after member label names in headings in PDF files. |
Display Supporting Detail | Note: This control is only displayed for a data row using the Planning database connection. When selected, and Supporting Detail exists for one or more cells in the row, additional rows are inserted to show the Supporting Detail. |
Allow Page Break Within | Note: This control is only displayed for a data row using the Planning database connection. It is enabled if you select Show Supporting Detail. When selected, a page break is allowed within the rows of Supporting Detail. When deselected, the member and all Supporting Detail are kept together. If the Supporting Detail is too long to fit on a page, the member and the Supporting Detail are moved to the next page. Note: For Auto Calculation rows, the Allow Page Break Within option is placed in the Auto Calculation dialog box so you can control the option by specific Auto Calculation. |
Show Unary Operator | Note: This control is only displayed for a data row using the Oracle Hyperion Planning database connection. It is enabled if you select Show Supporting Detail. When selected, the unary operator (+, —, /, *) is shown for all supporting detail rows. |
Page Break Before | Insert a page break before the row, then perform an action: For a row, select Position at Top to place remaining part of the grid at the top of the new page. For a column, select Position at Left to place remaining part of the grid to the left of the new page. Select Same Position to place the grid in the same position where it is currently placed. For example, if a grid is placed half way down the page and you insert a page break with Same Position selected, the remaining part of the grid is displayed half way down on the second page.
|
Related Content Setup | Select Add Related Content to create links to objects in Financial Reporting, then click Setup to specify the links within Related Content Setup. |
Adjust Column Width to Fit | You can change the column and row heading width to fit the contents of the cells. The default setting is based on the type of data in the column: Data / formula columns - the default setting is On. Text columns - the default setting is Off. Row heading columns - The default setting is Off.
|