Issue with Group Count Display in Syncfusion DataGrid for Paginated Records

[srimathi]

Issue Description:
The Group by column feature in the Syncfusion DataGrid is not displaying the correct record count when the total records exceed the Rows per page limit. Currently, the group count label only reflects the count for the records on the current page. If the last group spans multiple pages, its count is split across those pages instead of showing the total count for the group on both pages.

Example Scenario:

• Total Records: 1772
• Rows per Page: 1000
• Grouping Column: POSITION_TYPE

Actual Behavior:
On grouping by POSITION_TYPE, the record counts are displayed as follows:

• Page 1:

  • POSITION_TYPE: NONE - 46
  • POSITION_TYPE: POOLED - 225
  • POSITION_TYPE: SHARED - 236
  • POSITION_TYPE: SINGLE - 493

• Page 2:

  • POSITION_TYPE: SINGLE - 772

Here, the count for POSITION_TYPE: SINGLE is split between pages (493 on Page 1, 772 on Page 2).

Expected Behavior:
The group count for POSITION_TYPE: SINGLE should show the total rows and row count label (1235) on Page 1 itself, or display the total count (1235) label on both Page 1 and Page 2, reflecting the actual total records for the group

Is there a way to display the total group count on each page where records for that group appear? This would provide users with an accurate representation of the grouped data.

 

[Sethupathy Devarajan]

Hi Srimathi,

The grouping of records in the DataGrid is determined by the RowsPerPage property. In your case, the RowsPerPage count was set to 1000, which caused the DataGrid to fetch and group the first 1000 records. As a result, the first page shows a count of 493 under the POSITION_TYPE: SINGLE group, while the next page displays 772.

This behavior is the expected functionality of the SfDataGrid, as it does not support splitting records based on group categories. If you want the total row count (e.g., 1235) to appear on Page 1, you can achieve this by increasing the RowsPerPage count to 1772, or any other value that suits your needs.

Regards,
Sethupathy D.