PivotViewOptions Properties
Contains display settings for a pivot table.
Name | Description |
---|---|
Alt |
Gets or sets the alternative description of the information in a Pivot |
Alt |
Gets or sets the alternative text for a Pivot |
Column |
Gets or sets the text to be displayed in the column header of a pivot table shown in compact form. |
Data |
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. |
Error |
Gets or sets the text to be displayed in cells that contain errors. |
Grand |
Gets or sets the text to be displayed in grand totals for rows and columns in a pivot table. |
Missing |
Gets or sets the text to be displayed in cells with no values. |
Row |
Gets or sets the text to be displayed in the row header of a pivot table shown in compact form. |
Show |
Gets or sets a value indicating whether the expand/collapse buttons should be displayed in a pivot table. |
Show |
Gets or sets a value indicating whether to show custom error messages in cells. |
Show |
Gets or sets a value indicating whether to display the row and column field captions and filter drop-down arrows in a pivot table. |
Show |
Gets or sets a value indicating whether to display a custom string in cells that contain no values. |
Show |
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. |
Show |
Gets or sets a value indicating whether to display the Values row that may appear when there are multiple fields in the Pivot |
See Also