Skip to main content

ASPxPivotGrid.CreateDrillDownDataSource() Method

Returns data records used to calculate summary values for all cells.

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v23.1.dll

NuGet Package: DevExpress.Web


public PivotDrillDownDataSource CreateDrillDownDataSource()


Type Description

A PivotDrillDownDataSource object that contains the underlying data records.


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

This method obtains data for all cells. To obtain underlying data for a particular cell, use the CreateDrillDownDataSource method overloads with the columnIndex and rowIndex parameters.

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.

In server and OLAP modes, the CreateDrillDownDataSource method returns only visible fields. To get hidden field values, use the method’s overloads with the customColumns parameter which allow you to specify the columns to return.

See Also