May 24, 2012 at 8:11 am
Hello,
I'm building a report in SSRS. I have many datasets in the report.
The datasets are built based on a stored procedure that expects a parameter. Depending on the parameter the procedure retruns specific columns. No matter what parameter I pass the return is the same..
I have test my procedure it works perfectly..
It looks like what ever the first dataset have the other datasets would have as columns even though I'm calling them with different parameters that return different columns.
Any ideas ???
Thank you
May 24, 2012 at 5:39 pm
Sorry, I can't figure out what your question is?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 25, 2012 at 12:40 am
I don't think it is a good idea to have changing metadata in SSRS.
When you create the report, the column names will be embedded into the report.
If those change, the report will break.
I would create different stored procedures for each different set of metadata, instead of "one-that-fits-all".
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply