question

David 2 1 avatar image
David 2 1 asked

How To Dynamically Change Embedded Image in SSRS?

Hi, I am writing a report in SSRS 2012 Visual Studio which needs to contain an embedded image as the logo, however that image must dynamically change based on the customer type column in the report. How can I go about dynamically changing an embedded image based on this column. In the Report Data section under Images I have loaded the 2 images. I've dragged and dropped an Image from the Toolbox into the report then after right clicking and selecting Image Properties I have set the expression for 'use this image' as: =IIF(First(Fields!CUSTOMER_TYPE.Value, "CustomerDataSet") = "Local", "local.jpg", "global.jpg") Unfortunately this does not appear to work as the image just shows a small red cross. Can anyone help? TIA
ssrsssrs-2012dynamicimages
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
@SQLShark avatar image
@SQLShark answered
Hi, Do not include the extension of the file. If you expand the images node in the report data list and use the name as it appears in there.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.