Display a grid as a pivot

[Au]

I need to display a grid which looks like a pivot table with the data returned from the server in JSON format. How can I achieve that?

[Georgi Krustev]

Hello Au,

I would suggest you refer to our "Local binding" online demo, that demonstrates how to bind a flat data (in JSON format) into the pivotgrid. For more details, please refer to the API reference of the PivotDataSource instance.

Regards,
Georgi Krustev
Telerik

 

 

[Au]

Hi Georgi,

I don't think the "Local binding" way suits my need. I don't want to bind all raw data into pivotgrid component. I have another UI to pick up columns, rows and formulas then the pivotgrid will responsible for displaying the processed data only. I mean the data will be calculated on server side instead of client side.

Regards.

[Georgi Krustev]

Hello Au,

The other option is to bind the widget to a SSAS instance. Basically, the pivotgrid is designed to work with XMLA standard or its JSON representation. It will perform special XMLA requests, more specifically DISCOVER and EXECUTE, to retrieve only a chunk of the calculated data.
That being said, you will need to align your service to work with that standard. 
The other option is to write a custom transport and schema that will communicate with your service and will transform the received data in understandable for the widget format.

Regards,
Georgi Krustev
Telerik