How to Select Multiple Columns From A parameter in SSRS.

• vgone

  SSC Enthusiast

  Points: 137

  More actions

  March 5, 2012 at 5:18 am

  #258115

  I have a requirement like this..

  I have Two parameters Called "Project Title" and "Columns"

  In Project Title we are selecting the projects.

  In Columns we are selecting corresponding column names of that project.

  My problem is how can I select project corresponding “ Column names “ in the second parameter ???

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  March 5, 2012 at 7:50 am

  #1454799

  You need to set up your Columns parameter to depend upon the Project Title parameter

  Basically in the Columns parameter you create your query with a where clause that is fed by the value selected in your Project Title parameter

  Something like this

  SELECT Columns

  FROM tblProjectColumns

  WHERE ProjectTitle = @ProjectTitle

  The order of parameters matters as well, your Project Title Parameter should be on the top of the list.