PivotCellBaseEventArgs.CreateDrillDownDataSource(Int32, List<String>) Method

Returns a list of 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.Xpf.PivotGrid

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

NuGet Package : DevExpress.Wpf.PivotGrid

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

In server and OLAP modes, the CreateDrillDownDataSource method returns only visible fields. To get values of hidden fields, use the method’s overloads with the customColumns parameter.

Tip

Refer to the CreateDrillDownDataSource article for an example of use.