DxPivotTable Members
A Pivot Table component for multi-dimensional data analysis and cross-tab reporting.Constructors
Name | Description |
---|---|
DxPivotTable() | Initializes a new instance of the DxPivotTable class. |
Properties
Name | Description |
---|---|
AllowDragFields | Specifies whether users can drag field headers and drop them onto 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 Table 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. |
Fields | A collection of Pivot Table fields. |
FieldValueTemplate | Specifies a common template to display field values in rows or columns. |
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. |
SizeMode | Specifies the size of Pivot Table elements (for instance, text size and cell height). |
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. |
Equals(Object, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals(Object) | Determines whether the specified object is equal to the current object. Inherited from Object. |
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. |
GetHashCode() | Serves as the default hash function. Inherited from Object. |
GetType() | Gets the Type of the current instance. Inherited from Object. |
HideFieldList() | Hides the Field List. |
LoadLayout(PivotTablePersistentLayout) | Restores Pivot Table layout. |
MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
Reload() | Reloads Pivot Table data. |
SaveLayout() | Returns Pivot Table layout information so you can save it to a variable or a custom storage. |
SetFieldPosition(String, PivotTableArea, Int32) | Displays the field in the specified area and 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. |
ToString() | Returns a string that represents the current object. Inherited from Object. |
Events
Name | Description |
---|---|
CustomizeFilterMenu | Allows you to customize filter menu items. |
FieldPositionChanging | Fires after a user starts dragging a field to another area. |
FilterCriteriaChanged | Fires when filter criteria applied to Pivot Table data changes. |
LayoutAutoLoading | Fires when the DxPivotTable component is initialized and starts to load its layout. |
LayoutAutoSaving | Fires when the Pivot Table’s layout changes. |
See Also