PivotGridExtension.CreateDrillDownDataSource(PivotGridSettings, Object, Int32, Int32) Method
In This Article
Returns data records associated with the specified cell.
Namespace: DevExpress.Web.Mvc
Assembly: DevExpress.Web.Mvc5.v24.2.dll
NuGet Package: DevExpress.Web.Mvc5
#Declaration
public static PivotDrillDownDataSource CreateDrillDownDataSource(
PivotGridSettings pivotGridSettings,
object dataSource,
int columnIndex,
int rowIndex
)
#Parameters
Name | Type | Description |
---|---|---|
pivot |
Pivot |
A Pivot |
data |
Object | A Pivot |
column |
Int32 | An integer value that is the zero-based column index. |
row |
Int32 | An integer value that is the zero-based row index. |
#Returns
Type | Description |
---|---|
Pivot |
A Pivot |
#Remarks
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 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. |
See Also