Hi,
I am working with the grid extensively, and am implementing multiple workarounds for one main problem, the grid cannot work with data it does not have.
Many of the recordsets i am returning are greater than 50k in size. In order to satisfy bandwidth requirements, I have implemented a paging alogrithm with a page size of 1000 records.
The problem arises using groupbys. Because the grid is not bound to the entire dataset, but rather one page of it, grouping information is not accurate. Even if I override the grouping events and force the SQL to sort on whatever column i am grouping by, the information in the grid will not be accurate unless the size of the group <= paging size.
How would you suggest dealing with this problem?
– James
Imported from legacy forums. Posted by jraddock (had 1850 views)