I have a SSRS Report that has a dynamic .jpg Image1 in it. I have it set to External and am using the =IIF(IsNothing(Fields!location.Value),"","File:///"&Fields!location.Value) this is working just fine. I want to add another .jpg Image2 into the report. I have it setup the same =IIF(IsNothing(Fields!location2.Value),"","File:///"&Fields!location2.Value), the location fields are located in a SQL table called Drawing and is linked to a Table called Product. When I run the report the first I image desplays but the second one doesn't, I don't know what I am doing wrong. Any help would be appreciated.

Hi, Can you display the value of Fields!location2.value in a textbox and see if you get the correct path to the Image2 file? Regards, Vinaya

It won't display in text box. There is a value in the table. Regards Mark

I figured it out, it was my bad, I forgot to add the location2 field to my Stored Procedure. It works now... Thanks for your reply Regards Mark

Hi Mark, I am glad to hear that the issue has been resolved. Thanks for sharing. Regards, Charlie Liao TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedbackhere.