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.