Pivot Grid State Persistence

[Nate Greene]

Hey Guys,

Is there any way to save the work that a user has done with the pivot grid so that they could access their changes from the pivot grid control on the site at a later time? Currently everytime the control reloads it resets to its starting setup which is fine but some users need to customize what data is displayed on startup and for each user it would be different. Is there an example of a solution for this problem?

Thanks in advance,

Nate

[Sastha Prathap Selvamoorthy]

Hi Nate, 

 

Thank you for using Syncfusion products. 

 

We have already provided the “Save and Load Report” support for PivotGrid control and it will be available in the upcoming 2016 Volume 3 release which will be roll out at the end of September 2016. 

 

Regards, 

Sastha Prathap S. 

[ManniAT]

Hi,

I found http://mvc.syncfusion.com/demos/web/pivotgrid/saveandload which looks what you have promised.
Unfortunately it doesn't seem to work.

I type a name "WithAmount" and click save.
I remove "Amount" field
I type the name "NoAmount" and click save.

Both Names are now present in the combobox.
Next I chose the "WithAmount" and click load.
Nothing happens...

Also the documentation https://help.syncfusion.com/aspnetmvc/pivotgrid/overview shows nothing about "Save and load".
Also there is no notice in "What's new"... 

This is a bit frustrating.
Since your samples have just "plain view source" and not explanation I don't even know what the example should do - nor how it is done.
Also there is no Controller source with the MVC samples - so in this case (even if it would work) the sample doesn't answer the initial question...

How to save the work a user has done (of course on the server) and load it later again.
To be more precise - the sample looks almost like what I want to achieve...

I have a "Save as" and "Load" functionality.
BUT - that’s it -- not working - no explanation - no server side code..
Further OLAP / Relational / Server / Client is (I guess) "something else" which has nothing to do with the sample topic.
This just makes (from my point of view) the code more complex.

And the "missing field list" makes it impossible to bring back a field if you removed it.

 Can you provide a simple sample (snippet) how to achieve:
Place fields
Store the "layout" once a desired result is reached.
Load some "stored layouts".

 

Thank you 

Manfred

 

[Sastha Prathap Selvamoorthy]

Hi Nate, 

 

Sorry for the inconvenience caused. 

 

We have fixed the reported problem that occurred in Online sample browser. Please find the Online sample browser link below. 

 

Online Sample browser: http://mvc.syncfusion.com/demos/web/pivotgrid/saveandload 

 

Also, we have prepared a sample of for your reference that you can easily understand the concept how the report stored and retrieved from the database using WebAPI controller. Please find the sample in the below link. 

 

Sample link: http://www.syncfusion.com/downloads/support/forum/125751/ze/ServerSide1129216946 

 

 

Regards, 

Sastha Prathap S. 

[rohit]

Hi guys ,

I am trying to save the pivot grid here and I feel the issues still exists

https://reports.syncfusion.com/demos/aspnet-core/ReportDesigner?_ga=2.76625619.719497695.1566369441-795674323.1565063030

[Vinoth Srinivasan]

Hi Rohit, 

We have provided the all grouping and filtering support for Tablix Report item. So, we are going to remove the Gird and Pivot Grid report item in our ReportDesigner control in upcoming Report Platform release and it is estimated to release on 2019 September first week . So, could you please use the Tablix report item instead of Pivot Grid as shown in below help documentation to avoiding the mentioned problem at your end. 

https://reports.syncfusion.com/documentation/report-server/report-designer/compose-report/configure-report-items/tablix-reportitem/ 

Regards, 

Vinoth S.