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?
When you specify an expression for visibility, you are setting the Hidden property of the report item, as shown in the following image. The evaluated expression shows the report item when the value is False, and hides the report item when the value is True. Click OK twice.
The evaluated expression shows the report item when the value is False, and hides the report item when the value is True. Click OK twice. In report design view, click the table, matrix, or list to display the row and column handles. Right-click the row handle, and then click Row Visibility.
Bold Reports provides an Expression Builder that can be used to build expressions easily and quickly. The expression builder comprises a text editor at the top and built-in functions and data at the bottom. Under the Options drop-down, you can find the built-in fields, operators, and functions.
To select an entire table or matrix data region, click in the data region to select it, right-click a row, column, or corner handle, and then click Tablix Properties. Click Visibility. In When the report is initially run, specify whether to hide the item when you first view the report:
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)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With