PivotGridFieldBase.CollapseAll() Method

Collapses all rows/columns that correspond to the current column field or row field.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v19.1.Core.dll

Declaration

C#

public void CollapseAll()

VB.NET

Public Sub CollapseAll

Remarks

Use the PivotGridControl.ChangeFieldExpandedAsync method to collapse or expand all values of a particular field, asynchronously. For more information about asynchronous mode, see Asynchronous Mode.

To collapse a specific field value, use the PivotGridFieldBase.CollapseValue method. To expand field values, use the PivotGridFieldBase.ExpandValue and PivotGridFieldBase.ExpandAll methods.

Field values can be collapsed and expanded by end-users if the field’s PivotGridFieldOptions.AllowExpand property is set to true.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the CollapseAll() 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-the-group-filter-for-a-pivotgrid-e2315/CS/Form1.cs#L12

    this.pivotGridControl1.DataSource = GetTimeTableView();
    fieldMonth.CollapseAll();
}

winforms-customize-pivot-grid-data-before-displaying-it-in-a-chart-control/CS/Form1.cs#L50

chartControl1.DataSource = pivotGridControl1;
fieldCategoryName.CollapseAll();
fieldCategoryName.ExpandValue("Produce");

VB.NET

how-to-implement-the-group-filter-for-a-pivotgrid-e3721/VB/ASPxPivotGrid_GroupFilter/Default.aspx.vb#L22

    fieldShippedYear.ExpandAll()
    fieldShippedMonth.CollapseAll()
Case 2

how-to-implement-the-group-filter-for-a-pivotgrid-e2315/VB/Form1.vb#L14

    Me.pivotGridControl1.DataSource = GetTimeTableView()
    fieldMonth.CollapseAll()
End Sub

winforms-customize-pivot-grid-data-before-displaying-it-in-a-chart-control/VB/Form1.vb#L54

chartControl1.DataSource = pivotGridControl1
fieldCategoryName.CollapseAll()
fieldCategoryName.ExpandValue("Produce")