Display a grid as a pivot

4 posts, 0 answers
  1. Au
    Au avatar
    4 posts
    Member since:
    Sep 2014

    Posted 19 Apr 2015 Link to this post

    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?

  2. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3706 posts

    Posted 22 Apr 2015 Link to this post

    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
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Kendo UI is VS 2017 Ready
  4. Au
    Au avatar
    4 posts
    Member since:
    Sep 2014

    Posted 22 Apr 2015 in reply to Georgi Krustev Link to this post

    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.

  5. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3706 posts

    Posted 24 Apr 2015 Link to this post

    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
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
Back to Top
Kendo UI is VS 2017 Ready