Search code examples
sql-server-2008reporting-servicesembedded-resource

How to reference embedded SQL Server Reporting Service 2008 images

I have a SQL Server 2008 report with a bit field - IsUS

I'd like to display embedded images depending on IsUS bit value.
How can I reference embedded images within a column expression?

alt text




Below is the result after applying Fillet's answer
-------------------- Result --------------------

alt text

Solution

  • Drag the "checked" image into the Is US column. Then edit the properties of the image, and set the image expression to:

    =iif(Fields!IsUS.Value = 1, "checked", "unchecked")