Dynamic Coloumns To SSRS Report

• Subbu S

  Old Hand

  Points: 389

  More actions

  April 27, 2011 at 3:42 am

  #239215

  Hi All,

  I will be executing a stored procedure, it may return 10 coloumns or 20 coloumns or 30coloumns based on the passed parameter.

  I cannot proceed wit MATRIX report since i hav few problems in that

• srikant maurya

  Hall of Fame

  Points: 3293

  More actions

  April 27, 2011 at 3:54 am

  #1316441

  Use can return all 30 column from procedure depend upon parameter u can hide column in SSRS

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  April 27, 2011 at 6:54 am

  #1316519

  Define your report with all possible columns in mind. Then set the visibility of the optional columns according to the data returned.