Database Connection | Shows the database connection name from which the row receives data. |
Row Height / Column Width | Type the height for the selected rows, or type the width for the selected columns. |
Hide Always | Select to 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 | Perform an action: To ignore the data in the hidden rows / columns, select this option. When evaluating suppression, no cells in the hidden rows / columns are evaluated. To 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. For Oracle Essbase data source rows only. To return the Top N rows based on the values in a specified column, select a row, select Top, then select the value and the column. |
Heading - Suppress Repeats | Select to suppress 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. |
Display Supporting Detail | Note: This control is only displayed for a data row using the Planning Details 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 Details 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. For more information, see . |
Show Unary Operator | Note: This control is only displayed for a data row using the Planning Details database connection. It is enabled if you select Show Supporting Detail. When selected, the unary operator (+, —, /, *) is shown for all supporting detail rows. |
Display Line Item Details | This option is used in Financial Management rows only. Select to include line item detail in the report. |
Page Break Before | Select to 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 Related Content Setup to create links to objects in J2EE, Web Analysis, or Financial Reporting, then click Setup to specify the links within Related Content Setup. |
XBRL Context | This control is only displayed for a column if you enabled XBRL editing in the Preferences dialog box. Select XBRL Context to include information about the entity, units, period, and scenario (optional). |
XBRL Line Item | This control is only displayed for a row if you enabled XBRL editing in the Preferences dialog box. Select XBRL Line Item to include information about XBRL line items, then click Setup to assign XBRL line items to the selected data or formula row. |