ASPxPivotGrid.ExpandValue(Boolean, Object[]) Method

Expands the specified column or row.

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v18.2.dll

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 identifies the column/row to be expanded.

Remarks

The image below shows a pivot grid control with indexed column field values:

The following table lists the examples of using the ExpandValue method:

The ExpandValue method call example	The index of the expanded field value cell
ASPxPivotGrid.ExpandValue(true, new object[] {“UK”, “Beverages”, “1995”});	2
ASPxPivotGrid.ExpandValue(true, new object[] {“UK”, “Condiments”});	3
ASPxPivotGrid.ExpandValue(true, new object[] {“USA”});	5

Row field values are identified in the same manner as column field values.

To collapse a particular column/row, use the ASPxPivotGrid.CollapseValue method.

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#

how-to-implement-sorting-by-summary-in-olap-mode-e3092/CS/ASPxPivotGrid_OLAPSortBySummary/Default.aspx.cs#L18

// that correspond to the nested columns.
ASPxPivotGrid1.ExpandValue(true, new object[] { "Australia" });