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

POSTMAN D365

  Postman is useful to test the behavior of different OData class from/to D365FO. In this post we will see the steps to setup Postman with D...