PivotGridControl.CollapseAll() Method

Collapses all the columns and rows in the PivotGridControl.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v19.1.dll

Declaration

C#

public void CollapseAll()

VB.NET

Public Sub CollapseAll

Remarks

The CollapseAll method collapses all columns and rows which are currently expanded. If only the rows or the columns need to be collapsed, call the PivotGridControl.CollapseAllRows or PivotGridControl.CollapseAllColumns method, respectively.

To collapse a particular field value, use the field’s PivotGridFieldBase.CollapseValue method. To collapse all the values of a particular field, use its PivotGridFieldBase.CollapseAll method.

To collapse or expand all columns and rows asynchronously, use the PivotGridControl.CollapseAllAsync and PivotGridControl.ExpandAllAsync methods, respectively.

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-build-a-simple-data-analysis-application-using-the-xtrapivotgrid-e4672/CS/XtraPivotGridTutorial.Step3/Form1.cs#L24

    pivotGridControl1.FieldsCustomization(splitContainerControl1.Panel1);
    pivotGridControl1.CollapseAll();
}

how-to-generate-an-mdx-query-automatically-according-to-the-current-pivot-grid-layout-e2299/CS/WindowsApplication10/Form1.cs#L31

    adapter.RefreshDataSource();
    pivotGridControl1.CollapseAll();
}

how-to-mediate-a-pair-of-bridged-chart-and-pivot-grid-with-a-filter-control-e2597/CS/Form1.cs#L26

private void Form1_Load(object sender, EventArgs e) {
    pivotGridControl1.CollapseAll();
    chartControl1.Series.Clear();

VB.NET

how-to-build-a-simple-data-analysis-application-using-the-xtrapivotgrid-e4672/VB/XtraPivotGridTutorial.Step3/Form1.vb#L22

    pivotGridControl1.FieldsCustomization(splitContainerControl1.Panel1)
    pivotGridControl1.CollapseAll()
End Sub

how-to-generate-an-mdx-query-automatically-according-to-the-current-pivot-grid-layout-e2299/VB/WindowsApplication10/Form1.vb#L28

    adapter.RefreshDataSource()
    pivotGridControl1.CollapseAll()
End Sub

how-to-mediate-a-pair-of-bridged-chart-and-pivot-grid-with-a-filter-control-e2597/VB/Form1.vb#L28

Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load
    pivotGridControl1.CollapseAll()
    chartControl1.Series.Clear()