Grouped Kendo Grid with pagination

[Max]

Hello.

We are trying to implement pagination (with virtual scrolling instead of actual pages) for every group of Grid widget. So, we have Grid with serverPaging, serverGrouping and virtual scrolling. As far as I understand, Kendo Grid doesn't support paging if it's grouped. So, the idea is to return from server empty grouped results (with empty items for every group), collapse all groups by default and then after user opens a group - send separate request and populate just this particular group.

Could you please help us with implementation showing an example of something similar or tell any better way to reach the goal?

Just to make it clear - currently our grouped (aggregated) data can have millions of rows in every group.

 

Thank you.

Max

[Max]

Not sure how soon do you usually answer, but here is the example for better understanding - http://dojo.telerik.com/@paul/iGeGO

I'm setting the first level of grouping manually and then after you trying to open the group - I'm adding an item there, but for some reason it reloads everything.

Cheers,

Max

[Boyan Dimitrov]

Hello Max,

The Grid does not support loading the groups on demand. One possible way to implement this behavior is to bind the Grid to the group keys and use a detail to load the items for the group on demand. In the linked demo the detailInit event is fired once the expand icon is clicked. 

Regards,
Boyan Dimitrov
Telerik by Progress

 

 

[Max]

Hi Boyan,

Thanks for the response, yes, we were thinking about the solution with details tables inside the groups, but in this case we need to stretch it the same size as top level grid and synchronize each column width and position, plus implement our own drag'n'drop of multiple column headers for multiple grouping.

So, we decided that it would be easier just to dynamically add rows to dataSource. Here is the example, but for some reasons it doesn't work in your sandbox - http://dojo.telerik.com/@paul/iGeGO/2

 

Cheers, Max

[Nikolay Rusev]

Hello Max,

You will need to unsubscribe dataBound event after initial call, so that `grid.dataSource.at(0).set('items', fullResponse);` can expand the grid. Plus you should prevent default inside click handler in order to prevent browser from navigating the page.

http://dojo.telerik.com/@rusev/ixEdU

Regards,
Nikolay Rusev
Telerik by Progress