Dynamic Columns & Dynamic Grouping ???

Last Post 18 May 2007 12:18 PM by deadguy. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

11 Dec 2006 07:43 PM

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
New Member
New Member

18 May 2007 12:18 PM
As far as I know, your best bet for dynamic columns (headings) is to base the header off its own dataset. The remainder of the dynamic coulumns will then be in a stored procedure or a CLR.

As for the filters, you can filter data right from the properties of the report item that you link to the dataset. the filters can be set according to expressions just like all the other properties. If you open the properties screen on a table element, for example, one of the tabs is for specifying the filters.

Good luck with managing your reports. It seems like managability was not one of their primary design considerations.

Acceptable Use Policy