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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to modify the cell values at run-time in PivotGrid (Server Mode) control?

You can modify the cell values at run-time in PivotGrid (Server Mode) control by using below steps.

  1. Under the service methods InitializeGrid” and “DrillGrid, you will be able to get entire cell details from its JSON records in serialized format.

 

  1. The below line under the service method “InitializeGrid” populates the JSON records.

 

  1. Inside the JSON records, by using the dictionary key “PivotRecords, you can get the entire cell values in serialized format. By using below code, you can get the entire cell values in de-serialized format.

 

  1. Then by using below code, you can iterate entire cell values and modify them based on your requirement.

 

  1. Finally, the modified values need to be serialized and replaced to the dictionary “PivotRecords” in the JSON records then return.

 

  1. The same modifications need to be applied under the service method “DrillGrid” also.

 

The below code helps to modify the cell values at run-time based on your requirement.

 

C#:

 

 

 

VB.NET:

 

 

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8079 11/15/2017 11/16/2017 JavaScript ejPivotGrid
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon 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.Close Icon