PivotGridControl.CreateSummaryDataSource() Method

Returns a summary data source.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v23.2.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

public PivotSummaryDataSource CreateSummaryDataSource()

VB.NET

Public Function CreateSummaryDataSource As PivotSummaryDataSource

Returns

Type	Description
PivotSummaryDataSource	A PivotSummaryDataSource object that represents the summary data source.

Remarks

A summary data source is a table whose columns correspond to the fields, while the records correspond to the pivot grid data cells.

In the example below, the CreateSummaryDataSource method is used to create a summary data source which is then assigned to the Grid Control.

C#

DevExpress.XtraPivotGrid.PivotSummaryDataSource ds = pivotGridControl1.CreateSummaryDataSource();
gridControl1.DataSource = ds;

VB.NET

Dim ds As DevExpress.XtraPivotGrid.PivotSummaryDataSource = pivotGridControl1.CreateSummaryDataSource()
GridControl1.DataSource = ds

The image below shows the result:

To identify a column in a summary data source that corresponds to an unbound field, specify its name using the PivotGridFieldBase.UnboundFieldName property. An unbound field is not connected to a datasource field and it should be populated with data manually via the PivotGridControl.CustomUnboundFieldData event.