PivotGridControl.CreateDrillDownDataSource(Int32, Int32, Int32) Method

Returns data records used to calculate a summary value for the specified cell. Allows you to limit the number of returned records.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v19.1.dll

Declaration

C#

public PivotDrillDownDataSource CreateDrillDownDataSource(
    int columnIndex,
    int rowIndex,
    int maxRowCount
)

VB.NET

Public Function CreateDrillDownDataSource(
    columnIndex As Integer,
    rowIndex As Integer,
    maxRowCount As Integer
) As PivotDrillDownDataSource

Parameters

Name	Type	Description
columnIndex	Int32	A zero-based visible column’s index. Set it to -1 to get the column’s Grand Total.
rowIndex	Int32	A zero-based visible row’s index. Set it to -1 to get the row’s Grand Total.
maxRowCount	Int32	An integer value that specifies the maximum number of data rows to return. -1 to retrieve all rows.

Returns

Type	Description
PivotDrillDownDataSource	A PivotDrillDownDataSource object that contains the underlying data records.

Remarks

Note

For an example of use refer to the CreateDrillDownDataSource(Int32, Int32, Int32, List) topic.

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 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.

Important

Do not call the CreateDrillDownDataSource method in the PivotGridControl.CustomSummary and PivotGridControl.CustomUnboundFieldData event handlers to avoid a stack overflow exception. Use the event arguments’ methods instead - the PivotGridCustomSummaryEventArgsBase<T>.CreateDrillDownDataSource and CustomFieldDataEventArgsBase<T>.GetListSourceColumnValue methods, respectively).

In OLAP mode, this method equals to the PivotGridControl.CreateOLAPDrillDownDataSource method with the customColumns parameter set to null.