Save PivotGrid to xml file

[Eduard]

Hello,

Is it possible to save the columns/rows position to a xml file to load it later?

Thank you,
Eduard

[Ivan Todorov]

Hello Eduard,

Thank you for your questions.

Currently, this is not possible. Such a feature has already been requested and is available for voting in our Public Issue Tracking System. You can find the PITS item here: http://www.telerik.com/support/pits.aspx#/public/winforms/12936. As it gets more votes, we will consider scheduling it for a future release.

Should you have any additional questions, feel free to ask.

Regards,
Ivan Todorov
the Telerik team

[Brandmuscle]

Hello,

I'm wondering if there any updates related to this saving/loading XML layout request in the PivotGrid Control?

Thank you,
Julie

[Dess | Tech Support Engineer, Principal]

Hello Jacquelyn,

Thank you for writing.

We have introduced save/load layout support for our RadPivotGrid in Q3 2013 SP2 (version 2013.3.1328). For reference, here is the Feedback Item, related to this feature request.

You can have a look at our Demo application - PivotGrid - Settings, where the "Save" and "Load" buttons demonstrate how it works.

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik

 

 

[Miguel]

hi i need Save PivotGrid to sql ?

[Dess | Tech Support Engineer, Principal]

Hello Miguel,

Thank you for contacting us.

I am not sure that I understand your requirement completely. If you need to save the RadPivotGrid layout in SQL server, feel free to use the save/load layout functionality. Thus, you can store the xml data into SQL server. Please refer to XML Data Type and Columns (SQL Server) msdn article which is quite useful on this topic. Additionally, note that RadPivotGrid supports export to Excel. Hence, you can store the whole exported file by following some of the introduced approaches on the following links:

• http://stackoverflow.com/questions/2492469/datatype-to-save-excel-file-in-sql-server
• http://stackoverflow.com/questions/8234778/how-can-i-load-store-excel-xml-files-into-sql-server-tables-preserving-all-va

If it is not the exact requirement please specify in details what you are trying to achieve. Thus we would be able to assist you further. Thank you.

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik

 

 

[Brandmuscle]

Is this functionality available for the PivotGrid in Telerik UI for ASP.NET AJAX?

[Dess | Tech Support Engineer, Principal]

Hello Jacquelyn,

Thank you for writing.

I would like to note that this forum is related to RadPivotGrid from the Telerik UI for WinForms suite. Please post your question in the relevant forum: http://www.telerik.com/forums/aspnet-ajax/pivotgrid

Thank you for your understanding.

 

Regards,
Dess
Telerik