jcrawf02 (10/11/2012)
Interesting idea, have you seen a lot of use for this? Seems to me if the users wished to dig into the data and summarize on their own, they might be better served by exporting to Excel and using pivot tables? I suppose they might run into some data limitations given a large data set, but that would allow for multiple levels of grouping, etc that the report design does not.
I've written a few dynamic grouping reports in my past (mostly in crystal reports) and they've always been popular with management types who can't be bothered to fiddle around in Excel.
This is a pretty good example of how to do this and well done.