Table Properties dialog: Style tab

Use this tab of the "Table Properties dialog" to specify formatting preferences for tables and pivot tables.

For more information, see "Editing Table and Pivot Table Views."

This dialog is also displayed as:

Pivot Table Properties dialog

Components

Data Viewing

Use this area to specify the method to use to browse data:

• Fixed headers with scrolling content — Use this option to use scrolling as the method to browse data.

  When you select this option, the Maximum Width and Maximum Height fields are displayed in this dialog.

  A table or pivot table that uses this method:

  • Keeps headers of rows and columns visible at all times.

  • Includes horizontal and vertical scroll bars.

  • May include Get more rows and Get more columns links to fetch more rows and columns of data, when the table or pivot table has a large amount of data and the user scrolls to the bottom of the table or pivot table.

• Content paging — Use this option to use paging controls as the method to browse data.

  When you select this option, the Paging Controls box and the Rows per Page field are displayed in this dialog.

Maximum Width

This field is available only if Fixed headers with scrolling content is selected.

Use this field to specify the maximum width of the table or pivot table in pixels.

Maximum Height

This field is available only if Fixed headers with scrolling content is selected.

Use this field to specify the maximum height of the table or pivot table in pixels.

Paging Controls

This box is available only if Content paging is selected.

Use this box to specify where the paging controls are displayed for the view. The paging controls include First 25 Rows and Next 25 Rows. You can select either the top or bottom of the view or you can select to hide the controls. For information on the paging control buttons, see "Results tab: Data View editor."

Rows per Page

This field is available only if Content paging is selected.

Use this field to enter the number of rows to display per page for the view. This setting affects the number of rows that are displayed with the First, Next, and Previous paging control buttons.

Display Column & Folder Headings

Use this box to specify whether to display headings for the columns and the view. You can select from the following:

• Only column headings — Displays only the column headings, not the view headings.

• As separate rows — Displays the column and view headings as individual rows in the view.

• As Folder.Column — Displays the column names with the lowest-level folder name from the Subject Area. For example, suppose that you have a column called Color in the Products folder. With this option, the column heading displays as Products.Color, rather than simply Color.

• As Folder.Column (where needed) — Displays the column names with the folder name from the Subject Area but only when the column names are not unique. This option is available only for tables.

Enable alternate styling

Use this box to specify whether to add "green bar" styling to the view. Green bar styling shows alternating rows or columns in a light green color. (Light green is the default color, which you can change. For how, see "Applying Formatting to Tables and Pivot Tables.") Select this box to add green bar styling. Deselect it to omit green bar styling.

Alternate

This field is enabled only if you select the Enable alternate styling box and you are applying formatting to a pivot table.

Use this box to select one of the following options for green bar styling for pivot tables:

• Innermost Column — Applies green bar styling only to the column that is closest to the data.

• All Columns — Applies green bar styling to all columns.

Repeat Cell Values

Use this box to indicate that all cells that span rows are repeated. For example, suppose that you have a table that has Year and Month values. When this box is not selected, Year is displayed once for Month values. When this box is selected, Year is repeated for all Month values. This box is available only for tables.

Set Alternate Format

Use this button to display the "Edit Format dialog," where you add cosmetic formatting for the green bar styling of the view. See "Applying Formatting to Tables and Pivot Tables."

Listen to Master-Detail Events

Use this box to specify whether a table or pivot table is to act as a detail view in a master-detail relationship and listen for master-detail events. If you select this box, then complete the Event Channels field.

For information on master-detail relationships, see "What Is Master-Detail Linking of Views?"

Event Channels

This field is enabled only if you select the Listen to Master-Detail Events box.

Use this field to enter one or more channels on which the table or pivot table is to listen for master-detail events raised by one or more master views. The channel name is case sensitive and must match exactly the channel name specified in the master view. Separate channels with commas, for example, channel a, channel b.

The remaining components of this dialog are described in "Column Properties dialog: Style tab."

Null Values

Use these check boxes to override null suppression set at the analysis level.

Include rows with only Null Values — Use this check box to include null values in a table or pivot table view when the entire row contains all null values. When selected, null values are not suppressed for rows for the table or pivot table.

Include columns with only Null Values — This check box is available only for pivot table views. Use this check box to include null values in a pivot table view when the entire column contains all null values. When selected, null values are not suppressed for columns in the pivot table.

See "Understanding Null Suppression" for additional information.

Notes

• When a column is on the section edge, the table or pivot table shows all sections and does not allow scrolling per section. Thus, both the Data Viewing and the Rows per Page components are ignored.