1. Home
  2. Forum
  3. React - EJ 2
  4. Grid group caption: showing total count of group rows, not just the rows in the page

Grid group caption: showing total count of group rows, not just the rows in the page

Paging is enabled in my grid and pageSize is set to 25 in PageSettings. I can use count this works fine.

I grouped the rows by a column.

Try to imagine: in one group there are 39 records in total. But my pageSize is 25. I grouped the rows. I try to show the count and the result is naturally 25.


Here is the next page.


So what I'm trying to do is show the total count of records (39). How can I achieve this?


3 Replies 1 reply marked as answer
VS Vikram Sundararajan Syncfusion Team May 18, 2023 09:27 AM UTC

Hi K,


Greetings from syncfusion support,


Based on your query when grouping want to show the total count of items. You can use the DisablePageWiseAggregates property. This property support to the display total aggregated count in Grouped details based on entire datasource. We have already documented this topic in our ug documentation, and it can be referred from below  


DisablePageWiseAggregates: https://ej2.syncfusion.com/javascript/documentation/api/grid/groupSettings/#disablepagewiseaggregates


Group with paging: https://ej2.syncfusion.com/react/documentation/grid/grouping/grouping#group-with-paging


Sample: https://stackblitz.com/edit/t2xzsu?file=index.ts


If you require further assistance, please do not hesitate to contact us. We are always here to help you.


Regards,

Vikram S



Marked as answer
K K May 18, 2023 12:00 PM UTC

Worked like a charm! Thank you so much.


SG Suganya Gopinath Syncfusion Team May 22, 2023 06:35 AM UTC

We are glad that the provided solution helped to solve the issue. Please get back to us for further assistance.


Loader.
Up arrow icon