Skip to main content

PivotGridControl.CreateDrillDownDataSource(Int32, Int32) Method

Returns a list of records used to calculate a summary value for the specified cell.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid


public PivotDrillDownDataSource CreateDrillDownDataSource(
    int columnIndex,
    int rowIndex


Name Type Description
columnIndex Int32

A zero-based integer which is the visible column index. Set it to -1 to obtain the column’s Grand Total.

rowIndex Int32

A zero-based integer which identifies the visible index of the row. Pass -1 as a row index to obtain the row’s Grand Total.


Type Description

A PivotDrillDownDataSource object containing the underlying data records.



For an example of use refer to the CreateDrillDownDataSource(Int32, Int32, Int32, List<String>) topic.

The CreateDrillDownDataSource method retrieves data source records used to calculate current cell values.

If you use the CreateDrillDownDataSource method in OLAP mode, take note of the following limitations:

OLAP Server Note
MS SQL Server Analysis Services 2000 The customColumns parameter is ignored and the CreateDrillDownDataSource method returns the granularity attributes.
MS SQL Server Analysis Services 2005 and 2008 If the customColumns list is null or empty, the CreateDrillDownDataSource method returns the columns related to the current column, row and data PivotGrid fields. The method also returns filter fields, if any.
Any OLAP Server If returned records contain a column used as a filter in Pivot Grid, the returned data are filtered.
Any OLAP Server The CreateDrillDownDataSource is not applicable for fields which are calculated measures.
MS SQL Server Analysis Services - all versions Multiple filter items selected in a Filter field results in an exception.


Do not call the CreateDrillDownDataSource method in the PivotGridControl.CustomSummary and PivotGridControl.CustomUnboundFieldData event handlers to avoid a stack overflow exception. Use the event arguments’ methods instead - the PivotGridCustomSummaryEventArgsBase<T>.CreateDrillDownDataSource and CustomFieldDataEventArgsBase<T>.GetListSourceColumnValue methods, respectively).

In OLAP mode, this method equals to the PivotGridControl.CreateOLAPDrillDownDataSource method with the customColumns parameter set to null.

See Also