PivotCellBaseEventArgs.CreateDrillDownDataSource(List<String>) Method

Returns a list of records used to calculate a summary value for the current cell. Allows you to specify the columns to return.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v21.1.dll

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#

public PivotDrillDownDataSource CreateDrillDownDataSource(
    List<string> customColumns
)

VB.NET

Public Function CreateDrillDownDataSource(
    customColumns As List(Of String)
) As PivotDrillDownDataSource

Parameters

Name	Type	Description
customColumns	List<String>	A list of columns to return.

Returns

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

Remarks

Tip

Refer to the CreateDrillDownDataSource article for an example.

Important

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

The following limitations apply if you use the CreateDrillDownDataSource method in OLAP:

• For MS SQL Server Analysis Services 2000, the customColumns parameter is ignored. In this instance, the CreateDrillDownDataSource method returns the granularity attributes.
• A note for MS SQL Server Analysis Services 2005 and 2008. If the customColumns list is null or empty, the CreateDrillDownDataSource method returns the columns corresponding to the current column, row and data PivotGrid fields. In addition, it returns filter fields if a filter is applied to them. Otherwise, it returns the columns specified by the customColumns list.
• If a filter is applied to a field, then that filter is taken into account if the corresponding drill-down column was returned from the server by the CreateDrillDownDataSource method.
• The CreateDrillDownDataSource method is not supported for cells corresponding to calculated measures.
• If multiple filter items are selected in a Filter Field, the drill-down data source cannot be created due to an MS SQL Server Analysis Services limitation. In this instance, the CreateDrillDownDataSource method throws an exception.

In server mode, the CreateDrillDownDataSource method returns only visible fields. To get values of hidden fields, use the method’s overloads with the customColumns parameter which allow you to specify the columns to be returned.