PivotGridControl.ExpandValue(Boolean, Object[]) Method

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

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v22.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: