Creating Dynamic dataset with dynamic columns in SSRS

• nmalepati

  SSC-Addicted

  Points: 462

  More actions

  May 13, 2010 at 5:26 pm

  #224511

  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