Skip to main content
All docs
V25.1
  • 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