Dynamic Columns & Dynamic Grouping ???

[ngambhava]

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

[alexl]

Hi ngambhava!

Well, without knowing the exact business requirements it seems that one possible solution for you would be MS Reporting Services (part of SQL2005).

Reporting Services come with MS Business Intelligence Development Studio (a special version of Visual Studio for DB stuff). You can do all the grouping things with it and make nice headers and whatever else you need.

It also manages all the reports you define and users can access everything via web (IIS is required).

Check the MS SQL 2005 Server website

Hope its helps!
alexl