I'm currently evaluating my options for using RadGridView ( And maybe RadPivotGrid in the future ) in combination with large serverside datasets. For performance reasons we don't want to send the complete dataset to the client.
Therefore I'm now implementing a custom IQueryable provider that delegates grouping/paging/filtering to te serverside. For simple paging this works fine, I get simple Skip/Take requests on my IQueryable.
However when i start to use grouping I get a grouping request on my datasource, without any paging Skip/Take requests. This means that I should get all data from te server which is not acceptable for our solution.
What solution do you propose for this problem?