We would like to set up a report such the user viewing the report could drag and drop column headers and set up grouping in whatever order they want. What would be the best way to do this? Is it even possible, or do we have to create a separate report for each combination?
For example, One report just groups by Date and Type. They might also want to group by Type then Date. Other times we want Date, Type, then color.
I used to run the reports in a third party grid which supported this, but since it was all client side, it was very slow for large datasets.
You can change the grouping through report parameters. Chris has an example of this in his blog:
http://blogs.msdn.com/chrishays/archive/2004/07/15/DynamicGrouping.aspx
No comments:
Post a Comment