CODEWITHSUNDEEP
sqlreporting-services
wafw1971
wafw1971

Reputation: 361

Visibility Expression in Report Builder

I have 3 reports currently designed on Report builder 3 that run at the same time but I want to only show each report when it is selected in the Select Report Parameter.

I know I have to go into the Chart Properties and select Visibility based on an expression but I have no idea how to construct the expression.

The Parameter includes:

Occupancy PitchNightsSold Capacity

I thought all I needed to do is write the following expression:

=IIf(Parameters!WhichReport.Value = "Occupancy", true, false)

But it doesn't seem to work, can you help?

Upvotes: 5

Views: 20129

Answers (1)

Ravindra Gullapalli
Ravindra Gullapalli

Reputation: 9158

In the visibility property, you have to give the expression to hide the component. So you have to give true if you want to hide and false if you want to show the component. Change the expression to

=IIf(Parameters!WhichReport.Value = "Occupancy", false, true)

Upvotes: 14

Related Questions