CrossTable Preferences


Preference Group/Preference

Description

   CrossTablePreferences

 

      BlankEmptyCellText

Specifies whether to leave the cells with no data unfilled  (True) or whether to use a text instead (False).

      Default Title

Specifies the default title of new cross tables. For example, it can be the current data table name: ${DataTable.DisplayName}

      EmptyCellText

Specifies the default text to show in empty cells. If this preference is left unchanged but the BlankEmptyCellText preference is set to False, the predefined default text in the text field will be a dash, -.

      ExportCrossTableData

Specifies whether or not a web client user is allowed to export the data from the cross table.

      Font

Lets you specify font settings for the text in the cross table cells.

      HeaderFont

Lets you specify font settings for the cross table headers.

      LegendVisible

Specifies whether or not the legend should be displayed when creating a new cross table.

      ShowColumnGrandTotals

Specifies whether or not the sum of all values in a column should be displayed.

      ShowGridlines

Specifies whether or not cell borders should be visible in the cross table.

      ShowRowGrandTotals

Specifies whether or not the sum of all values in a row should be displayed.

      SubtotalsLayout

Specifies whether to place the subtotals Before or After the cell values in the hierarchy of the vertical axis.

      TotalsFont

Lets you specify font settings for the cross table subtotals and grand total.

      UseSeparateColorForMarkedItems

Specifies whether the cross table should use a separate color for marked cells or just dim the unmarked cells.

See also:

The Preferences tab

Viewing Preferences

Preferences Examples

Setting Primary Group