PivotGridControl.CreateDrillDownDataSource(Int32, Int32) Method
Returns a list of records used to calculate a summary value for the specified cell.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.XtraPivotGrid.v24.2.dll
NuGet Package: DevExpress.Win.PivotGrid
#Declaration
public PivotDrillDownDataSource CreateDrillDownDataSource(
int columnIndex,
int rowIndex
)
#Parameters
Name | Type | Description |
---|---|---|
column |
Int32 | A zero-based integer which is the visible column index. Set it to -1 to obtain the column’s Grand Total. |
row |
Int32 | A zero-based integer which identifies the visible index of the row. Pass -1 as a row index to obtain the row’s Grand Total. |
#Returns
Type | Description |
---|---|
Pivot |
A Pivot |
#Remarks
Note
For an example of use refer to the Create
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. |
Important
Do not call the Create
In OLAP mode, this method equals to the PivotGridControl.CreateOLAPDrillDownDataSource method with the customColumns parameter set to null.