Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 668
wafw1971 Avatar asked Mar 11 '13 10:03

wafw1971


People also ask

How do I set the visibility of a report item?

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.

How do I display the evaluated expression in report design view?

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.

How do I use the expression builder?

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.

How do I change the visibility of a tablix report?

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:


1 Answers

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)

like image 187
Ravindra Gullapalli Avatar answered Nov 14 '22 22:11

Ravindra Gullapalli