Text Row / Column Properties

Table 43. Text Row/Column Properties Sheet

Item

Use

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 Oracle Hyperion Financial Reporting Studio.

Suppression Ignores Row / Column

  • Select to ignore the data in the hidden rows / columns. When evaluating suppression, no cells in the hidden rows / columns are evaluated.

  • Deselect to include the data in the hidden rows / columns. 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.

Page Break Before

Inserts a page break before the row, then specify one of the following positions:

  • 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 as 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.

Add Related Content

Select Add Related Content to create links to objects in Financial Reporting, then click Setup to specify the links within the Add Related Content dialog.