I will pass the parameter as below for variable param.
• All
• Train
• Taxi
Param should be either All/Train/Taxi
Now based on the parameter value I need to display/hide the row
Right click on the row(train/bus details) -> properties -> visibility -> expression
Now give validation in expression as
=IIF(Parameters!Param = “All” or Parameters!Param = “Train”,False,True)
By setting the above expression, the row will be made visible only when the property is
either All or Train
For the second row, go to the visibility property and set the expression as
=IIF(Parameters!Param = “All” or Parameters!Param = “Taxi”,False,True)
• All
• Train
• Taxi
Param should be either All/Train/Taxi
Now based on the parameter value I need to display/hide the row
Right click on the row(train/bus details) -> properties -> visibility -> expression
Now give validation in expression as
=IIF(Parameters!Param = “All” or Parameters!Param = “Train”,False,True)
By setting the above expression, the row will be made visible only when the property is
either All or Train
For the second row, go to the visibility property and set the expression as
=IIF(Parameters!Param = “All” or Parameters!Param = “Taxi”,False,True)
By setting the above expression, the row will be made visible only when the property is
either All or Taxi
either All or Taxi
No comments:
Post a Comment