Creating Dynamic dataset with dynamic columns in SSRS

  • 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