ASPxPivotGrid.CreateDrillDownDataSource(Int32, Int32, Int32) Method
Returns data records associated with the specified cell. Used in OLAP and server mode.
Namespace: DevExpress.Web.ASPxPivotGrid
Assembly: DevExpress.Web.ASPxPivotGrid.v24.2.dll
NuGet Package: DevExpress.Web
#Declaration
public PivotDrillDownDataSource CreateDrillDownDataSource(
int columnIndex,
int rowIndex,
int dataIndex
)
#Parameters
Name | Type | Description |
---|---|---|
column |
Int32 | An integer value that specifies the zero-based column index. Set it to -1 to obtain the column’s Grand Total. |
row |
Int32 | An integer value that is the zero-based absolute row index. Set it to -1 to obtain the row’s Grand Total. To obtain the absolute row index by the visible row index within the current page, use the ASPx |
data |
Int32 | An integer value that identifies the data field by its index. |
#Returns
Type | Description |
---|---|
Pivot |
A Pivot |
#Remarks
The CreateDrillDownDataSource method retrieves data source records used to calculate current cell values.
The image below shows how this method’s parameters identify a cell.
Important
Do not call the Create
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. |