ASPxPivotGrid.CreateDrillDownDataSource(Int32, Int32) Method
Returns data records associated with the specified cell.
Namespace: DevExpress.Web.ASPxPivotGrid
Assembly: DevExpress.Web.ASPxPivotGrid.v24.2.dll
NuGet Package: DevExpress.Web
#Declaration
public PivotDrillDownDataSource CreateDrillDownDataSource(
int columnIndex,
int rowIndex
)
#Parameters
Name | Type | Description |
---|---|---|
column |
Int32 | An integer value that is the zero-based column index. Set it to -1 to obtain the column’s Grand Total. |
row |
Int32 | An integer value that is the absolute (not the visible) zero-based 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 |
#Returns
Type | Description |
---|---|
Pivot |
A Pivot |
#Remarks
The CreateDrillDownDataSource method retrieves data source records used to calculate current cell values.
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. |
#Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the CreateDrillDownDataSource(Int32, Int32) method.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.