Hi Satheesh,
Thanks for your interest in Syncfusion products.
We could able to understand your scenario. As per paging support in GridGroupingControl, the number of pages count will be declared by the total records count of grid and by default, the records of the current page will be loaded on demand only in grid when moves to next page based on PageSize. This is the default behaviour of Paging.
The paging in grid does not have direct support for loading the records on demand. Already we have logged feature report for “Loading the records for each page on demand directly from the server”. This feature will be available in any of our upcoming releases.
Thanks for your patience.
Regards,
Piruthiviraj