Category / Section
How To Collapse or Expand the rows or columns in PivotGridControl
2 mins read
C#
Example: To collapse a single column: pivotGridControl1.CollapseColumn("Australia"); To expand a single column: pivotGridControl1.ExpandColumn ("Australia"); To collapse a single row: pivotGridControl1.CollapseRow("Bike"); To expand a single row: pivotGridControl1.ExpandRow("Bike"); To collapse entire column (For Example: ColumnHeader name->“Country” which has columns like “Australia”, ”Canada” ,”France”) List<string> columnHeaders = new List<string> { "Australia", "Canada", "France" }; pivotGridControl1.CollapseColumn(columnHeaders); To collapse entire row( For Example: RowHeader name-> “Product” which has rows like “Bike” and “Car” List<string> rowHeaders = new List<string> { "Bike", "Car" }; pivotGridControl1.CollapseRow(rowHeaders); To expand entire row /Column pivotGridControl1.ExpandAllGroup();
Figure: Pivot Grid shows single collapsed row (Bike)
Figure: Pivot Grid shows single collapsed column (Canada)