Can I handle variable columns returned from a stored procedure? -- sql server reporting services

pichula
11/9/2006 6:47:19 AM

I recently started with SQL Reporting Services. I was able to call a
report from a web page passing some parameters through the URL, then
calling a stored prcedure to get the results and rendering the results
in an Excel spreadsheet.

All that works fine. Now, my problem is that some of the fields
(columns) returned by the stored procedure are variable. Depending on
the parameters I pass I may get a certain number of fields returned.

Is there any way I can handle this from the report designer (I'm
working with an .rdl file)? I noticed that I can define fields in the
report, but only in a static way, where I can only define in advance
which fields I'm going to get returned from the stored proc.

Thanks for any help I can get.

Pablo

Bruce L-C [MVP]
11/9/2006 9:29:32 AM

RS does not handle variable number of fields. You can have them all and then
based on the parameter hide fields so they don't show on the report.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

sql server reporting services : Can I handle variable columns returned from a stored procedure?