Grouping large list with paging

[Keith A Price]

I have a dataset with about 6,000 records. And it could get close to 10,000.

Paging performance (100 per page) is stellar.

The Grouping feature doesn't seem to work as I would expect.

Let's say I have 5 Categories: "One" "Two" "Three" "Four" "Five".

I drag Category to Group box.

I would expect to get five collapsed rows; one for each Category. 

Instead, I get just one row -- say, for all the Ones.

Suppose I have 500 Ones. I get a collapsed row of Ones for the first 5 pages, each stating a Count of 100.

My preferred behavior would be one row per Category, with total counts (500 Ones).

Then, if I expand a category row, I get paging (so I still only see 100 detail rows per page).

Does that make sense?

[Renjith Singh Rajendran]

Hi Keith, 

Greetings from Syncfusion support. 

By default, when paging is enabled in grid on the rows in the current view will be rendered in Grid(say 100 rows). Paging works based on load on demand concept, to improve performance. So when enabling paging, the aggregate will be displayed only on the loaded set(100 rows) of records. This is the default behavior.  

To overcome this behavior, we have support for LazyLoading Grouping in Grid in our latest versions(19.2.0.60). Now, you can use the LazyLoadingGrouping feature to disable page wise aggregate during grouping.  

Please refer the below references for more details regarding Lazy Loading Group feature.  

Documentation : https://blazor.syncfusion.com/documentation/datagrid/grouping/#lazy-load-grouping 

Online demo : https://blazor.syncfusion.com/demos/datagrid/lazyloadgroup?theme=bootstrap4 

Please get back to us if you need any further assistance.   

    

Regards,              

Renjith R