Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  How to display report with dynamic columns

Author  Topic  Erin Starting Member 1 Post Posted - 2007-10-05 : 11:31:58 I have a report that is generated from some dynamic sql. The first 10 columns or so are known entities but following those there could be any number of columns with column headers of values that come from the data and are not known in advance. In certain grid applications I can simply invoke a dataset.bind() method and the data returned from the stored proc is displayed in the grid. Is there a similar command in Reporting Services? If not, how can I design for an unknown number of columns with unknown values? I can't use the matrix (from what I understand) because much of the data in the other columns is not aggregatable. Maybe I'm not using it correctly? Any help would be greatly appreciated.