PivotCellEventArgsBase<TField, TData, TCustomTotal>.CreateDrillDownDataSource(Int32, List<String>) Method

Returns data records used to calculate a summary value for the current cell. Allows you to specify the columns and limit the number of records to return.

Namespace : DevExpress.XtraPivotGrid

Assembly : DevExpress.PivotGrid.v25.2.Core.dll

NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

csharp

public PivotDrillDownDataSource CreateDrillDownDataSource(
    int maxRowCount,
    List<string> customColumns
)

Public Function CreateDrillDownDataSource(
    maxRowCount As Integer,
    customColumns As List(Of String)
) As PivotDrillDownDataSource

Parameters

Name	Type	Description
maxRowCount	Int32

An integer value that specifies 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 records used to calculate a summary value for the current cell.

Remarks

Important

The customColumns parameter is in effect in Server and OLAP modes only; otherwise, it is ignored.

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.