paging in pivotgrid

6 posts, 0 answers
  1. Mul
    Mul avatar
    3 posts
    Member since:
    Nov 2014

    Posted 09 Nov 2014 Link to this post

    how do i set the datasource in the pivotgrid to the correct data generate in the pivotgrid in the paging?
    for example: in my datasource i have 500 rows which generate into 250 rows and 250 colums in the pivot grid. 
    how to i take the new data size which was created in the pivotgrid and not from the datasource for calculation the paging for the pivotgrid?

    i use this: 
         $("#pager").kendoPager({
                        dataSource: result.data,                         /* not correct*/
                        pageSizes: [10, 25, 50]
                    });

    when the result.data is the 500 rows that was arrived from the original datasource.
  2. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3707 posts

    Posted 10 Nov 2014 Link to this post

    Hello Mul,

    The PivotDataSource component does not support paging. In general, there is no clear way (at least to my knowledge) to page data retrieved from an OLAP instance. Note that this is applicable for the flat data binding too.

    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. rwb
    rwb avatar
    19 posts
    Member since:
    Aug 2015

    Posted 09 Jun in reply to Georgi Krustev Link to this post

    Paging in the pivotGrid is badly needed when working with anything but the most trivially small datasets.

    The display can be paged in both directions according to the row and column headers. 

    The XMLA properties BeginRange and EndRange will perform the paging.

    You can calculate appropriate values and page boundaries from the number of members in each dimension.

  5. Alex Hajigeorgieva
    Admin
    Alex Hajigeorgieva avatar
    118 posts

    Posted 14 Jun Link to this post

    Hello both,

    Currently there is no paging functionality in the Kendo UI Pivot Grid. However, please share your idea in the User Voice Forum below:

    http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/category/170004-pivot-grid

    If it gains enough popularity, we will consider implementing it in a future release.

    Kind Regards,
    Alex
    Telerik
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
  6. rwb
    rwb avatar
    19 posts
    Member since:
    Aug 2015

    Posted 31 Aug Link to this post

    Example of DevExpress (admittedly MVC version only; not JS) with paging and sorting by measure.
  7. Alex Hajigeorgieva
    Admin
    Alex Hajigeorgieva avatar
    118 posts

    Posted 02 Sep Link to this post

    Hi Richard,

    The feedback we receive in the UserVoice portal is instrumental in determining future enhancements or features. If the feature has not been requested yet, then we assume that there is no demand and harness our efforts in other popular areas so more of our clients can benefit. 

    Please check the UserVoice portal and create the idea as it does not exist. Alternatively, cast your vote for possibly the closest idea to paging that we have there - the DevExpress Compact Layout as it seems to incorporate paging here: http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/suggestions/7861869-pivot-grid-compact-layout.

    Regards,
    Alex
    Telerik by Progress
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
Back to Top
Kendo UI is VS 2017 Ready