ASPxPivotGrid.CreateDrillDownDataSource(Int32, Int32, Int32, List<String>) Method
Returns data records used to calculate a summary value for the specified cell in OLAP and server mode. Allows you to specify the columns, and limit the number of records to return.
Namespace: DevExpress.Web.ASPxPivotGrid
Assembly: DevExpress.Web.ASPxPivotGrid.v24.1.dll
NuGet Package: DevExpress.Web
Declaration
public PivotDrillDownDataSource CreateDrillDownDataSource(
int columnIndex,
int rowIndex,
int maxRowCount,
List<string> customColumns
)Parameters
| Name | Type | Description |
|---|---|---|
| columnIndex | Int32 | A zero-based visible column’s index. Set it to -1 to obtain the column’s Grand Total. |
| rowIndex | Int32 | A zero-based integer which identifies the absolute index of the row. Pass -1 as a row index to obtain the row’s Grand Total. Pass -1 as a column index to obtain the column’s Grand Total. To obtain the absolute row index by its index within the current page, use the ASPxPivotGrid.GetAbsoluteRowIndex method. |
| maxRowCount | Int32 | An integer value that is the maximum number of data rows to return. Set it to -1 to retrieve all rows. |
| customColumns | List<String> | A list of columns to return. |
Returns
| Type | Description |
|---|---|
| PivotDrillDownDataSource | A PivotDrillDownDataSource object that contains the underlying data. |
Remarks
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. |
In server and OLAP modes, the CreateDrillDownDataSource method returns only visible fields. To get hidden field values, use the method’s overloads with the customColumns parameter which allow you to specify the columns to return.