Dynamic Columns & Dynamic Grouping ??? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Dynamic Columns & Dynamic Grouping ???

Hi, We need to design more than 500 Reports for our ongoing project and we are dealing with MS SQL Server 2005 Reporting Services first time. We are currently confused in 2 things 1)How to manage Reports? I mean we should store entire report in database and load at runtime or simply store as a report file
2)Most Important is Dynamic Columns & Dynamic Grouping. We need something like Microsoft Office Accounting 2007 Reports. Header part of form has some parameters for filter and right part has some parameters for showing or hiding and reordering columns and groups.
We are not getting clue for this dynamic stuff. Can any one post working sample or at least necessary basic code with some idea? Thanks lot

you may store the reports as .rdl files and deploy to the reporting server once report is ready for use. below are some links that may help:
http://www.codeproject.com/useritems/DataGrouping.asp hope these examples are able to help out.