IIF statement not showing the tablix values

Question

I am building a report in report builder 3.0 with 3 tables.

Table 1: ABC

Table 2: DEF

Table 3: GHI

My report contains a drop down list of these 3 tables, I am using the IIF statement to hide the other 2 tables when 1 of them is selected.

For example, I choose ABC, the other tables DEF and GHI are hidden.

The statement is... =iif(Parameters!Deliverable.Value="ABC", False, True)

My problem, I also have another item in the drop down list that says "All" which should display all 3 of the tables. In order to do that I added this to every visibility expression... =iif(Parameters!Deliverable.Value="ABC" OR Parameters!Deliverable.Value="All", False, True).

This ended up giving me the tablix only... not the data that was inside it. What should I do to fix it?

The empty Tablix

Answer 1

You don't need to use IIF in this instance you just need to write an expression that evaluates to true or false.

For you 'ABC' table the hidden property expression would be

=Parameters!Deliverable.Value <> "ABC" AND Parameters!Deliverable.Value <> "All"

So in this example, it reads "Hide if both ABC and All are not selected"