IPivotTable Members

An interface that defines the DxPivotTable component’s API members (properties and methods).

Properties

Name	Description
AllowDragFields	Specifies whether users can drag field headers and drop them to other areas.
AllowDragFieldsInFieldList	Specifies whether users can drag fields in the Field List.
AllowFieldListDeferredUpdate	Specify whether to enable the Defer Layout Update option in the Field List.
AllowFilterInFieldList	Specifies whether users can apply field filters in the Field List.
AllowSortInFieldList	Specifies whether users can change field sort order in the Field List.
Attributes	Specifies a collection of standard HTML attributes applied to the Pivot Table.
AutoExpandGroups	Specifies whether to automatically expand all groups when the Pivot loads data.
ColumnTotalsPosition	Specifies the position of column totals.
CssClass	Assigns a CSS class to the Pivot Table.
Data	Specifies an object that supplies Pivot Table data.
FieldCellTemplate	Specifies a common template for all data cells in the Pivot Table.
FieldFilterMenuTemplate	Specifies a common template used to display all Field Filter Menus in the Pivot Table.
FieldHeaderTemplate	Specifies a common template to display field captions in the header area.
FieldPositionChanging	Fires after a user starts dragging a field to another area.
FieldValueTemplate	Specifies a common template to display field values in rows or columns.
FilterCriteriaChanged	Fires when filter criteria applied to Pivot Table data change.
FilterHeaderAreaDisplayMode	Specifies when to display the Filter Header Area in the Pivot Table.
FilterMenuButtonDisplayMode	Specifies when field headers display filter menu buttons.
RowTotalsPosition	Specifies the position of row totals.
ShowColumnGrandTotals	Specifies whether to display column grand totals.
ShowColumnTotals	Specifies whether to display column totals.
ShowRowGrandTotals	Specifies whether to display row grand totals.
ShowRowTotals	Specifies whether to display row totals.
VirtualScrollingEnabled	Specifies whether vertical virtual scrolling is enabled.

Methods

Name	Description
BeginUpdate()	Suspends Pivot Table updates caused by parameter changes and method calls until the EndUpdate() method is called.
ClearFilter()	Clears the filter applied to Pivot Table data.
CollapseAllColumns()	Collapses all columns in the Pivot Table component.
CollapseAllGroups()	Collapses all groups in the Pivot Table component.
CollapseAllRows()	Collapses all rows in the Pivot Table component.
EndUpdate()	Resumes Pivot Table updates (when the BeginUpdate() method pauses updates) and re-renders the Pivot Table.
ExpandAllColumns()	Expands all columns in the Pivot Table component.
ExpandAllGroups()	Expands all groups in the Pivot Table component.
ExpandAllRows()	Expands all rows in the Pivot Table component.
GetFields()	Returns a collection of Pivot Table fields.
GetFilterCriteria()	Returns the filter criteria applied to Pivot Table data.
HideFieldList()	Hides the Field List.
LoadLayout(PivotTablePersistentLayout)	Restores the Pivot Table layout.
Reload()	Reloads Pivot Table data.
SaveLayout()	Saves information about the Pivot Table layout.
SetFieldPosition(String, PivotTableArea, Int32)	Positions the field at the specified area, sets the field’s index.
SetFilterCriteria(CriteriaOperator)	Applies a filter to Pivot Table data.
SetFilterCriteria(String)	Applies a filter to Pivot Table data.
ShowFieldList()	Displays the Field List.
ShowFieldList(DialogDisplayOptions)	Displays the Field List and positions it based on specified display options.

Controls

FREE UTILITIES

Controls and Extensions

FREE UTILITIES

Controls

FREE UTILITIES

Controls and Extensions

FREE UTILITIES

IPivotTable Members

Properties

Methods