0

Hi i am creating a report using SSRS and i am getting value for this report from a store procedure; now i'd like to create a parameter which should have only YES and NO values in the drop down list. Base on this value when i should select YES i want a new column to be added inside the report with data and when i should select NO that column should disappear.

how can i achieve that?

aduguid
  • 3,099
  • 6
  • 18
  • 37
deep
  • 41
  • 1
  • 12

1 Answers1

1

Create a parameter p_costcentre with available values as Yes and No and based on the parameter selected value set the column visibility of the column Cost Centre as : iif(Parameters!p_costcentre.value = "Yes",false,true).

Nikhil Shetkar
  • 346
  • 1
  • 9