PivotGridControl.ExpandValue(Boolean, Object[]) Method

Expands a specific column or row that is identified by the specified values.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v23.2.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

public void ExpandValue(
    bool isColumn,
    object[] values
)

VB.NET

Public Sub ExpandValue(
    isColumn As Boolean,
    values As Object()
)

Parameters

Name	Type	Description
isColumn	Boolean	true to expand a column; false to expand a row.
values	Object[]	An array of values that identify the column/row to be expanded.

Remarks

To expand a column or row asynchronously, use the PivotGridControl.ExpandValueAsync method.

To collapse a column or row, use the PivotGridControl.CollapseValueAsync (asynchronous) or PivotGridControl.CollapseValue (synchronous) method.

Consider the following PivotGrid control:

To expand the “Austria” column (within the “Alice Mutton” column), use the following code:

C#

pivotGridControl1.ExpandValue(true, new object[] {"Alice Mutton", "Austria"});

VB.NET

pivotGridControl1.ExpandValue(True, New Object() {"Alice Mutton", "Austria"})

The result of this operation is shown below:

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ExpandValue(Boolean, Object[]) 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#

winforms-pivotgrid-implement-sorting-by-summary-in-olap-mode/CS/XtraPivotGrid_OLAPSortBySummary/Form1.cs#L13

// that correspond to the nested columns.
pivotGridControl1.ExpandValue(true, new object[] { "Australia" });
// Obtains OLAP members corresponding to the Australia and Bendigo values.

VB.NET

winforms-pivotgrid-implement-sorting-by-summary-in-olap-mode/VB/XtraPivotGrid_OLAPSortBySummary/Form1.vb#L17

' that correspond to the nested columns.
pivotGridControl1.ExpandValue(True, New Object() {"Australia"})
' Obtains OLAP members corresponding to the Australia and Bendigo values.