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.
Unfortunately, activation email could not send to your email. Please try again.

Design Pivot Table in Excel

Thread ID:

Created:

Updated:

Platform:

Replies:

124634 Jun 20,2016 05:46 AM Jun 22,2016 12:33 AM ASP.NET Web Forms 3
loading
Tags: XlsIO
Juan
Asked On June 20, 2016 05:46 AM


Hello,

I have set up a Pivot Table with XlsIO, and want to change your design as in Excel "Report Design" ==> "Show in tabular format".
By default, the design appears as Pivot Table "Show in compact form".

Is there any property to change the design?

Greetings.



Sridhar Sukumar [Syncfusion]
Replied On June 21, 2016 05:59 AM

Hi Juan, 
 
Thank you for contacting Syncfusion support. 
 
Yes, you can change the pivot table’s report design by using RowLayout property. Please refer the following code snippet to change the pivot table report design as Show in tabular format. 
 
pivotTable.Options.RowLayout = PivotTableRowLayout.Tabular; 
 
 
We also have prepared a sample for the above behavior which can be downloaded from the following link. 
 
 
Regards, 
Sridhar S. 


Juan
Replied On June 21, 2016 06:04 AM

Perfect!
Thank you very much!


Sridhar Sukumar [Syncfusion]
Replied On June 22, 2016 12:33 AM

Hi Juan,  
 
Thank you for updating us. 
   
We are glad to know that the issue has been resolved at your side. Please let us know if you need any further assistance on this.  
   
Regards,  
Sridhar S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

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.

;