Search code examples
reporting-servicesssrs-tablix

How to filter tablix rows based on boolean report parameter in ssrs


NetWtGreaterThan0 is report parameter(boolean)

Net Wt. Difference is calculated column

Here NetWtGreaterThan0 is a boolean report parameter. If value of NetWtGreaterThan0 is true than i want to show rows with Net Wt. Difference>0.000. Here Net Wt. Difference is calculated column.


Solution

  • Give this a try.

    In the Row Visibility, Show / Hide based on expression.

    =IIF(Parameters!NetWtGreaterThan0.Value = False, False, IIF(Net Wt. Difference>0.000, False, True))