Row Properties

row properties iconRow Properties

Row properties affect an entire row. You must click in a row header to select the row that you want to view the properties for. Use row properties to override the default grid settings for row height, repeated headings, and suppression settings.

Use row properties to edit the following:

Table 4-3 Review the Row Properties

Property Name Descriptions

Height

For row height, you can either:

  • Use the default grid row height

  • Specify a fixed row height

  • Specify a minimum row height, where the height will be auto-sized to fit the resulting content

Display

Show or Hide the row

Row Banding

There are three property settings for Row Banding that can be set; Grid Setting (off), On, or Off. The default is Grid Setting (Off).

Page Break Before

Inserts a page break before the row.

Repeated Heading

If you have the text and/or separator rows between the column header and data rows that you want to repeat with the row 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 row headings will include the rows which have the property enabled.

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

Note:

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

Trailing Characters

You can enable trailing characters (dot, dash, underscore, or custom), for data and formula rows, to be displayed at the end of the header label that extends the width of the row header. Trailing characters are enabled and specified by selecting one or more data or formula rows and in Row properties, setting the Trailing Characters property to Dot, Dash, Underscore or Custom. The default setting is None.

Note:

  • The Trailing Characters property does not apply to text or separator rows.

  • If there are multiple dimensions in the rows, the trailing characters are only displayed for the inner-most dimension.

  • The use of a custom trailing characters are now an option. For Reports to be used in a Report Package, the user needs to use one of the pre-defined trailing characters.

Note Template

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

For more information, see Setting the Allow Note Entry Property

Suppression

  • Zero Values

  • No Data

  • No Access

  • Error

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