PivotGridControl Class

In This Article

Declaration

Represents the PivotGridControl.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v14.2.dll

#Declaration

C#
VB.NET

[TemplatePart(Name = "PART_ThemesLoader", Type = typeof(DXPivotGridThemesLoader))]
[ComplexBindingProperties("DataSource")]
[DXToolboxBrowsable]
[OLAPDataAccessMetadata("All", SupportedProcessingModes = "Pivot", OLAPConnectionStringProperty = "OlapConnectionString", OLAPDataProviderProperty = "OlapDataProvider", DataSourceProperty = "DataSource")]
[TemplatePart(Name = "PART_Scroller", Type = typeof(PivotGridScroller))]
public class PivotGridControl :
    Control,
    IPrintableControl,
    IPivotGridEventsImplementor,
    IPivotGridEventsImplementorBase,
    ILogicalOwner,
    IInputElement,
    IWeakEventListener,
    ISupportInitialize

<TemplatePart(Name:="PART_ThemesLoader", Type:=GetType(DXPivotGridThemesLoader))>
<ComplexBindingProperties("DataSource")>
<DXToolboxBrowsable>
<OLAPDataAccessMetadata("All", SupportedProcessingModes:="Pivot", OLAPConnectionStringProperty:="OlapConnectionString", OLAPDataProviderProperty:="OlapDataProvider", DataSourceProperty:="DataSource")>
<TemplatePart(Name:="PART_Scroller", Type:=GetType(PivotGridScroller))>
Public Class PivotGridControl
    Inherits Control
    Implements IPrintableControl,
               IPivotGridEventsImplementor,
               IPivotGridEventsImplementorBase,
               ILogicalOwner,
               IInputElement,
               IWeakEventListener,
               ISupportInitialize

#Returned By

Properties and methods that return PivotGridControl instances:

#Remarks

The PivotGridControl represents data from a data source in cross-tab form. It calculates summaries and summary totals against specific fields and displays the summary values within data cells. The following summary functions are supported: Sum, Average, Count, Min, Max, StdDev, StdDevp, StdVar, StdVarp.

pivotgrid_FarColumnTotals

Fields are basic blocks, representing data source fields, which an end-user can manipulate in the PivotGridControl. Fields are visually represented by field headers, which can be moved between the pivot grid's areas using drag-and-drop. Dragging fields between areas allows you to reorganize the data and present it in various forms. The collection of fields can be accessed via the PivotGridControl.Fields property. Individual fields are represented by the PivotGridField class and can be accessed using indexed notation.

For detailed information on key features introduced by the DXPivotGrid, see: