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