1. Designing with Reports for Oracle Enterprise Performance Management Cloud
  2. Working with Grids
  3. Adding a Grid
  4. About Grid Properties
  5. Column Properties

Column Properties

column properties iconColumn Properties

Column properties affect an entire column. You must click in a column header to select the column that you want to view the properties for. Use column properties to override the default grid settings for column width, repeated headings, and suppression settings. The grid setting is displayed in brackets. For example, in the suppression setting for zeroes, Grid Setting (False) indicates that zero values are not suppressed at the grid level. Click the setting to override the suppression settings for the selected column with True (always suppress zeroes) or False (never suppress zeroes), or to use the default for the grid.

Use column properties to edit the following:

Table 4-2 Review the Column Properties

Property Name Descriptions

Width

For column width, you can either:

  • Use the default grid column width.

  • Specify a fixed column width.

  • Specify a minimum column width, where the width will be auto-sized to fit the resulting content in the data cells. For column heading, the column minimum width needs to be sized to fit the desired width of the heading cells.

Display

Show or Hide the column

Page Break Before

Inserts a page break before a column

Repeated Heading

If you have the text and/or separator columns between the row header and data columns that you want to repeat with the column headings in HTML and PDF preview, you can use the Repeated Heading property. When enabled (By default Repeated Heading is set to No):

  • In PDF preview, after any page break, the column headings will include the columns which have the property enabled.

  • In HTML preview, the text or separator columns will be "sticky" along with any heading columns.

Note:

The property is only applicable for text and separator columns in Column Properties which occur at the beginning of the columns. The property is not applicable for any text or separator columns that occur after one or more data or formula columns.

Suppression

Select whether you want to suppress zeroes, cells with no data, errors or no access for data cells in the row.

Note Template

In Narrative Reporting deployments, for Note Columns, you select a Note Template.

For more information, see Setting the Allow Note Entry Property.