Save and Load Report of Pivot Report with WEB API

Question

Hi, I would like to save and load Pivot Report to SQL Server Database through ASP.Net Core WEP API.Do you have a sample for that?Thank you so much.

Saranya Sivan · Accepted Answer

Hi Hai Nguyen Duy, 
  
Thanks for contacting Syncfusion Support. 
  
The pivot table allows to store its report in desired location(database). And it can be achieved in sample level by using following events. 
  
FetchReport:  This event allows user to fetch the report names from database and populate the dropdown list. 
  
LoadReport: This event allows user to load the selected report to the pivot table. 
  
SaveReport:  This event allows user to save the altered report to the report list. 
  
Please find the Sample link and UG link for your reference. 
  
Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/7z/PivotCoreExample-1215012715 
  
UG Link: https://ej2.syncfusion.com/aspnetcore/documentation/pivot-table/tool-bar/#fetchreport 
  
Please let us know if you have concern. 
  
Regards, 
Saranya Sivan.

Saranya Sivan · Answer

Hi Hai Nguyen Duy,  
 
We are validating the reported requirement (To Save and Load Pivot Report with WebAPI). And we will update you the further details in two business days (30th Dec, 2020)     
 
Regards,   
Saranya Sivan.

Susan Baker · Answer

This did not answer the question. I also am having trouble loading/saving the pivot table config from the database. The example given here was loading from local storage. I don't want to use local storage at all. I have tried to use the client side events

fetchReport, loadReport and saveReport without any luck. Even though I use ajax to pull the report names from the database, the dropdown list does not populate anything.

Manikandan Murugesan · Answer

Hi Susan, 
 
We've prepared a sample for saving and loading reports from a SQL Server database. For more information, please see the link below. 
Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Pivot-431066654 
 
Please let us know if you have any concerns. 
 
Regards, 
Manikandan.