Tuesday, 13 September 2016

parameter wise hidden in reports

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)
By setting the above expression, the row will be made visible only when the property is
either All or Taxi

No comments:

Post a Comment

8 Common Errors in Dual-write

502 Bad Gateway : when the target application is not ready to handle the incoming request  401 Unauthorized / 403 Forbidden: This error occ...