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