SSRS BIDS expression Show/Hide image based on passed through parameter

sql-server reporting-services expression bids ssrs-expression
JsonStatham picture JsonStatham · Feb 17, 2012 · Viewed 8.9k times · Source

Is it possible to have an image available if a certain field is selected, in this case the parameter is @employeename, I only want the image that has been placed on the report to display if a certain value is true.

What is the syntax, field i am concerned with is employeename

enter image description here

Answer

Yuck picture Yuck · Feb 17, 2012

The expression would be something like:

=IIf(Fields!employeename.Value = "Something", True, False)

You can have "Something" be a hard-coded value or another parameter. The key thing to remember is you have to access the .Value property.

Related questions

SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report …

Read More
Add alternating row color to SQL Server Reporting services report

How do you shade alternating rows in a SQL Server Reporting Services report? Edit: There are a bunch of good answers listed below--from quick and simple to complex and comprehensive. Alas, I can choose only one...

Read More
Tablix: Repeat header rows on each page not working - Report Builder 3.0

I have a tablix with lots of rows that span over multiple pages. I have set the Tablix property Repeat header rows on each page but this does not work. I read somewhere that this is a known bug in …

Read More