PivotGridExtension.CreateDrillDownDataSource(PivotGridSettings, Object, Int32, Int32, Int32) Method
Returns data records associated with the specified cell.
Namespace: DevExpress.Web.Mvc
Assembly: DevExpress.Web.Mvc5.v24.1.dll
NuGet Package: DevExpress.Web.Mvc5
Declaration
public static PivotDrillDownDataSource CreateDrillDownDataSource(
PivotGridSettings pivotGridSettings,
object dataSource,
int columnIndex,
int rowIndex,
int dataIndex
)Parameters
| Name | Type | Description |
|---|---|---|
| pivotGridSettings | PivotGridSettings | A PivotGridSettings object that contains PivotGrid settings. |
| dataSource | Object | A PivotGrid data source. |
| columnIndex | Int32 | An integer value that is the zero-based column index. |
| rowIndex | Int32 | An integer value that is the zero-based absolute row index. |
| dataIndex | Int32 | An integer value that is the data field index. |
Returns
| Type | Description |
|---|---|
| PivotDrillDownDataSource | A PivotDrillDownDataSource object which contains records associated with the specified cell. |
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.
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 customColumns parameter is ignored and the CreateDrillDownDataSource method returns the granularity attributes. |
| MS SQL Server Analysis Services 2005 and 2008 | If the customColumns list is null or empty, the CreateDrillDownDataSource method returns the columns related to the current column, row and data PivotGrid fields. The method also returns filter fields, if any. |
| 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 CreateDrillDownDataSource is not applicable for fields which are calculated measures. |
| MS SQL Server Analysis Services - all versions | Multiple filter items selected in a Filter field results in an exception. |