CODEWITHSUNDEEP
reporting-servicesssrs-tablix
Ravi Matani
Ravi Matani

Reputation: 822

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.

Upvotes: 2

Views: 1778

Answers (1)

SS_DBA
SS_DBA

Reputation: 2423

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))

Upvotes: 3

Related Questions