December 6, 2016 at 5:48 am
Hi
Can anyone help please - I have a report that has two sub reports, the second sub-report needs to toggle images depending on the parameter value of the main report.
In my database I have a lookup field and one containing the image path for example:
OId | TreatmentFunctionorSpec | OutcomeImage
1 | 120 | file:\\TGHDATAWARE\SSRS Images\COS Images\ENT.png
4 | 330 | file:\\TGHDATAWARE\SSRS Images\COS Images\sepsis_sticker.png
If I use a table it just displays the link rather than the image - I have seen examples of using blob to store the image in the DB but I would rather keep the images in a separate folder as they may change often.
I have also tried using the background image but cannot seem to connect it to the dataset to display the relevant image based on the parameter/dataset
Please can anyone advise?
December 6, 2016 at 7:34 am
sarah.hampson (12/6/2016)
HiCan anyone help please - I have a report that has two sub reports, the second sub-report needs to toggle images depending on the parameter value of the main report.
In my database I have a lookup field and one containing the image path for example:
OId | TreatmentFunctionorSpec | OutcomeImage
1 | 120 | file:\\TGHDATAWARE\SSRS Images\COS Images\ENT.png
4 | 330 | file:\\TGHDATAWARE\SSRS Images\COS Images\sepsis_sticker.png
If I use a table it just displays the link rather than the image - I have seen examples of using blob to store the image in the DB but I would rather keep the images in a separate folder as they may change often.
I have also tried using the background image but cannot seem to connect it to the dataset to display the relevant image based on the parameter/dataset
Please can anyone advise?
Make sure your image source property is set to "External", and also be sure that SSRS runs under a domain account on the domain the server hosting the image is part of, as opposed to a local service account, as that local service account is probably not going to qualify as part of "Everyone".
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 6, 2016 at 7:38 am
Thank you - that has worked! I had the image property set to database instead of internal.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply