wpf-devexpress-dot-xpf-dot-pivotgrid-dot-pivotgridcontrol-dec7df7d.md
Collapses all rows.
Namespace : DevExpress.Xpf.PivotGrid
Assembly : DevExpress.Xpf.PivotGrid.v25.2.dll
NuGet Package : DevExpress.Wpf.PivotGrid
public void CollapseAllRows()
Public Sub CollapseAllRows
To collapse all rows asynchronously, use the PivotGridControl.CollapseAllRowsAsync method.
To expand all rows, use the PivotGridControl.ExpandAllRowsAsync (asynchronous) or PivotGridControl.ExpandAllRows (synchronous) method.
To expand or collapse all columns asynchronously, use the PivotGridControl.ExpandAllColumnsAsync and PivotGridControl.CollapseAllColumnsAsync methods, respectively (or the PivotGridControl.ExpandAllColumns and PivotGridControl.CollapseAllColumns methods to do this synchronously).
This example shows how to implement custom group intervals in Pivot Grid to group axis values.
<Window xmlns:dxpg="http://schemas.devexpress.com/winfx/2008/xaml/pivotgrid"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="MainWindow" Height="350" Width="525"
x:Class="HowToBindToMDB.MainWindow"
Loaded="Window_Loaded">
<Grid>
<dxpg:PivotGridControl DataProcessingEngine="Optimized"
HorizontalAlignment="Left" Name="pivotGridControl1"
VerticalAlignment="Top">
<dxpg:PivotGridControl.Fields>
<dxpg:PivotGridField Name="fieldProductGroup" Area="RowArea"
Caption="Product Group">
<dxpg:PivotGridField.DataBinding>
<dxpg:ExpressionDataBinding Expression="Iif(Substring([fieldProductName], 0, 1) < 'F', 'A-E', Substring([fieldProductName], 0, 1) < 'T', 'F-S', 'T-Z')" />
</dxpg:PivotGridField.DataBinding>
</dxpg:PivotGridField>
<dxpg:PivotGridField Name="fieldProductName" Area="RowArea"
Caption="Product Name" >
<dxpg:PivotGridField.DataBinding>
<dxpg:DataSourceColumnBinding ColumnName="ProductName" />
</dxpg:PivotGridField.DataBinding>
</dxpg:PivotGridField>
<dxpg:PivotGridField Name="fieldExtendedPrice"
Area="DataArea" CellFormat="c0">
<dxpg:PivotGridField.DataBinding>
<dxpg:DataSourceColumnBinding ColumnName="Extended Price"/>
</dxpg:PivotGridField.DataBinding>
</dxpg:PivotGridField>
<dxpg:PivotGridField Name="fieldCountry"
Area="ColumnArea" >
<dxpg:PivotGridField.DataBinding>
<dxpg:DataSourceColumnBinding ColumnName="Country"/>
</dxpg:PivotGridField.DataBinding>
</dxpg:PivotGridField>
</dxpg:PivotGridControl.Fields>
</dxpg:PivotGridControl>
</Grid>
</Window>
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the CollapseAllRows() 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.
wpf-pivot-custom-group-intervals/CS/HowToCustomGroupInterval/MainWindow.xaml.cs#L22
salesPersonDataAdapter.Fill(salesPersonDataTable);
pivotGridControl1.CollapseAllRows();
}
wpf-pivot-custom-group-intervals/VB/HowToCustomGroupInterval/MainWindow.xaml.vb#L20
salesPersonDataAdapter.Fill(salesPersonDataTable)
Me.pivotGridControl1.CollapseAllRows()
End Sub
See Also