How to Save Layout of changed field for Pivot Table on run time

[Jasem ALheket]

Hi 

i am using Pivot Table control of JS2 for MVC 5 , 

i already enabled the the field list option ,it is a great option , but i have once concern if the there is an option to save the end-user modification of the layout to use it later ,

i found this article https://help.syncfusion.com/aspnet/pivotgrid/save-load but it is about ASP.NET form and version JS 1 

could anyone help me 

Thankx

[Deivaselvan Y]

Hi Jasem, 

 

Thanks for contacting Syncfusion support. 

 

You can get the report at any time by using getPersistData method and save it into the database. Please refer the below code snippet. 

  

Code Snippet: 

document.getElementById("save-btn").addEventListener('click', function () { 

        var pivotGridObj = document.getElementById('PivotGrid').ej2_instances[0]; 

        var dataSource = JSON.parse(pivotGridObj.getPersistData()).dataSource; 

        localStorage.pivotReport = JSON.stringify(dataSource); 

}); 

document.getElementById("load-btn").addEventListener('click', function () { 

        var pivotGridObj = document.getElementById('PivotGrid').ej2_instances[0]; 

        var dataSource = JSON.parse(localStorage.pivotReport); 

        pivotGridObj.dataSource = dataSource; 

});  

 

Sample: http://www.syncfusion.com/downloads/support/forum/143952/ze/PIVOTG~1474751329 

 

Please let us know if you have any other queries. 

 

Regards,
Deivaselvan