May 13, 2010 at 5:26 pm
Hello All,
I need to execute 8 to 10 different stored procedures on a single report ( one at a time). The procedure that needs to be run will be selected based on few parameter filters. Remember that no parameters will be passed to the Procedures.
I will just run the procedures and its output must be shown in the SSRS report. The problem is not all SP's have same number of columns, one may have 3 columns, one may have 4 or 5 columns. Is there a way to dynamically create the dataset and columns during runtime? or we need to pre-define only during runtime?
I tried researching many articles but didnt found any that clear my questions. Hiding & unhiding the columns is not the solution I am looking for.
It will be really great if someone can help me out with this.
Thanks
Naresh
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy