If I'm dealing with large datasets and hence doing all the processing on the server (paging, grouping etc) is there any way to determine when groups are collapsed?
I want to be able to show aggregates for each group but allow the user to see them all on one page by collapsing them. Due to size of the datasets I don't won't to pass all the data to the client, therefore I use server side paging.
Example:
I have a list of 10,000 customers and I want to produce a grid with 100 items per page that groups the data by Continent. The server will do the paging, grouping and aggregation. The output will be a list of groups like
Africa Count=10,000
Europe Count=30,000
N. America Count=20,000.
I want the end user to be able to see the overall summary in one go. The way it's seems to work is that I have to scroll through every page to find the summary information for a group. The user has no way of knowing that some groups even exist unless they go through every page. I also want the user to be able to group by a different field (e.g. Language) and have the groups regenerated with the possibility to collapse all groups and see the summary information.
I want to be able to show aggregates for each group but allow the user to see them all on one page by collapsing them. Due to size of the datasets I don't won't to pass all the data to the client, therefore I use server side paging.
Example:
I have a list of 10,000 customers and I want to produce a grid with 100 items per page that groups the data by Continent. The server will do the paging, grouping and aggregation. The output will be a list of groups like
Africa Count=10,000
Europe Count=30,000
N. America Count=20,000.
I want the end user to be able to see the overall summary in one go. The way it's seems to work is that I have to scroll through every page to find the summary information for a group. The user has no way of knowing that some groups even exist unless they go through every page. I also want the user to be able to group by a different field (e.g. Language) and have the groups regenerated with the possibility to collapse all groups and see the summary information.