We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to collapse columns or row

Platform: Silverlight |
Control: PivotGridControl |
Published Date: November 26, 2014 |
Last Revised Date: November 26, 2014

We can collapse column/row by passing unique text of the expander header. Hence we should pass all the column headers to collapse entire column headers.

C#

List<string> columnHeaders = new List<string> { "Australia", "Canada", "France" }; ////List of string header which are belongs to Country (Which is added in pivot columns) group.

pivotGridControl1.CollapseColumn(columnHeaders); //// Collapse the given headers at pivot grid control.

pivotGridControl1.CollapseColumn("Australia");////Collapses only the Australia which is belongs to Country ((Which is added in pivot columns) group.

List<string> rowHeaders = new List<string> { "Bike", "Car" }; ////List of string header which are belongs to Product (Which is added in pivot rows) group.

pivotGridControl1.CollapseRow(rowHeaders);////Collapses the both Bike and Car.

pivotGridControl1.CollapseRow("Bike");////Collapses only the Bike which is belongs to Product ((Which is added in pivot rows) group.

 

 

 

C:\Users\labuser\Dropbox\Screenshots\Screenshot 2014-06-11 10.36.40.png

Figure: Pivot Grid shows all columns collapsed

 

 

 

 

 

 

 

 

 

 

C:\Users\labuser\Dropbox\Screenshots\Screenshot 2014-06-11 10.36.48.png

 

Figure: Pivot Grid shows all Columns Expanded

 

 

 

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon