ASPxPivotGrid.CreateDrillDownDataSource(Int32, Int32, List<String>) Method
Returns data records used to calculate a summary value for the specified cell in OLAP and server mode. Allows you to specify the columns to return.
Namespace: DevExpress.Web.ASPxPivotGrid
Assembly: DevExpress.Web.ASPxPivotGrid.v24.2.dll
NuGet Package: DevExpress.Web
#Declaration
public PivotDrillDownDataSource CreateDrillDownDataSource(
int columnIndex,
int rowIndex,
List<string> customColumns
)
#Parameters
Name | Type | Description |
---|---|---|
column |
Int32 | A zero-based visible column’s index. Set it to -1 to obtain the column’s Grand Total. |
row |
Int32 | A zero-based absolute row’s index. Set it to -1 to obtain the row’s Grand Total. To get the absolute row index by its visible index in the current page, use the ASPx |
custom |
List<String> | A list of columns in a data source to return. |
#Returns
Type | Description |
---|---|
Pivot |
A Pivot |
#Remarks
Important
The custom
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 custom |
MS SQL Server Analysis Services 2005 and 2008 | If the custom |
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 Create |
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.