Skip to main content
Row

PivotViewOptions Properties

Contains display settings for a pivot table.
Name Description
AltTextDescription Gets or sets the alternative description of the information in a PivotTable report.
AltTextTitle Gets or sets the alternative text for a PivotTable report.
ColumnHeaderCaption Gets or sets the text to be displayed in the column header of a pivot table shown in compact form.
DataCaption Gets or sets the caption for a virtual field named Data (Values in the UI) which appears in a pivot table containing two or more data fields.
ErrorCaption Gets or sets the text to be displayed in cells that contain errors.
GrandTotalCaption Gets or sets the text to be displayed in grand totals for rows and columns in a pivot table.
MissingCaption Gets or sets the text to be displayed in cells with no values.
RowHeaderCaption Gets or sets the text to be displayed in the row header of a pivot table shown in compact form.
ShowDrillIndicators Gets or sets a value indicating whether the expand/collapse buttons should be displayed in a pivot table.
ShowError Gets or sets a value indicating whether to show custom error messages in cells.
ShowFieldHeaders Gets or sets a value indicating whether to display the row and column field captions and filter drop-down arrows in a pivot table.
ShowMissing Gets or sets a value indicating whether to display a custom string in cells that contain no values.
ShowMultipleLabels Gets or sets a value indicating whether to display the “(Multiple Items)” string in the report filter area when multiple items, but not all, are selected in a page field.
ShowValuesRow Gets or sets a value indicating whether to display the Values row that may appear when there are multiple fields in the PivotTable data area.
See Also