PivotGridControl.CreateDrillDownDataSource(Int32, Int32) Method

Returns a list of records used to calculate a summary value for the specified cell.

Namespace : DevExpress.Xpf.PivotGrid

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

NuGet Package : DevExpress.Wpf.PivotGrid

Declaration

• C#
• VB.NET

public PivotDrillDownDataSource CreateDrillDownDataSource(
    int columnIndex,
    int rowIndex
)

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

Parameters

A zero-based integer which identifies the visible index of the column. Pass -1 as a column index to obtain the column’s Grand Total.

| | rowIndex | Int32 |

A zero-based integer which identifies the visible index of the row. Pass -1 as a row index to obtain the row’s Grand Total.

|

Returns

A PivotDrillDownDataSource object that contains the underlying data.

|

Remarks

In OLAP mode, calling this method is equivalent to calling the PivotGridControl.CreateOlapDrillDownDataSource method with the customColumns parameter set to null.

If you use the CreateDrillDownDataSource method in OLAP, take note of the following limitations:

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

Note

Calling the CreateDrillDownDataSource method from the PivotGridControl.CustomSummary and PivotGridControl.CustomUnboundFieldData event handlers may result in a stack overflow exception. To provide custom cell values that require obtaining the underlying data to be calculated, call the corresponding methods provided by the current event arguments (PivotCustomSummaryEventArgs.CreateDrillDownDataSource and PivotCustomFieldDataEventArgs.GetListSourceColumnValue, respectively).

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the CreateDrillDownDataSource(Int32, Int32) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

• C#
• VB.NET

wpf-pivot-grid-define-custom-cell-template-to-performing-data-editing/CS/HowToEditCell/PivotGridEditHelper.cs#L204

public PivotDrillDownDataSource CreateDrillDownDataSource() {
    return pivotGrid.CreateDrillDownDataSource(cellItem.ColumnIndex, cellItem.RowIndex);
}

wpf-pivot-grid-define-custom-cell-template-to-performing-data-editing/VB/HowToEditCell/PivotGridEditHelper.vb#L223

Public Function CreateDrillDownDataSource() As PivotDrillDownDataSource
    Return pivotGrid.CreateDrillDownDataSource(cellItem.ColumnIndex, cellItem.RowIndex)
End Function

See Also

PivotGridControl Class

PivotGridControl Members

DevExpress.Xpf.PivotGrid Namespace