I have tried many different ways to display an image that changes based on a field value.
If I put an image control and set the URL to the image, it works fine but when I use a formula the image does not appear. I have also put the image URL in a variable and then assign the variable to the image control as image URL and the image didn't appear.
I have also tried to add a variable type as image but when I click on the "Open" button nothing happens.
Dynamic image with formula
Re: Dynamic image with formula
Hello.
Could you send us any sample? What formula did you use?
Is there the same path to image?
If you use different domain, then read Security Violation forum topic.
Thank you.
Could you send us any sample? What formula did you use?
Is there the same path to image?
If you use different domain, then read Security Violation forum topic.
Thank you.
Re: Dynamic image with formula
I have figured out a way to do it.
I added an image in my report then saved that mrt file on my desktop and then opened the mrt file in Notepad.
Then I copied the value of the image into another empty text file.
I closed the mrt that I opened with NotePad and go back in the designer.
I added a variable as image with the value I previously saved in a text file.
I did the same for the other images.
Then I added a calculated column as image type and I use the appropriate variable based on the value of another field.
And finally I used that calculated column in an image control.
My solution is not the easiest one but it worked in my case.
Everything is on the same domain so the security violation forum topic does not apply in my case.
I have attached my report but you will not be able to access the data.
I added an image in my report then saved that mrt file on my desktop and then opened the mrt file in Notepad.
Then I copied the value of the image into another empty text file.
I closed the mrt that I opened with NotePad and go back in the designer.
I added a variable as image with the value I previously saved in a text file.
I did the same for the other images.
Then I added a calculated column as image type and I use the appropriate variable based on the value of another field.
And finally I used that calculated column in an image control.
My solution is not the easiest one but it worked in my case.
Everything is on the same domain so the security violation forum topic does not apply in my case.
I have attached my report but you will not be able to access the data.
- Attachments
-
- sebcdataband.mrt
- (164.94 KiB) Downloaded 370 times
Re: Dynamic image with formula
Hello.
It's an interesting solution.
This will be interesting more other customers.
Thank you.
It's an interesting solution.
This will be interesting more other customers.
Thank you.