How do I get jpeg images into a formula?
I want a report to display one of 3 jpeg images, depending on the value of a field. I'd love to say something like the following in a formula:
if fieldA = 1 then jpeg1
else if fieldA =2 then jpeg2
else jpeg3
As a get around, I have the 3 jpeg images on top of each other in the report, with a formula in the suppression condition that controls whether or not that jpeg image is displayed. Eg, for jpeg1, I have fieldA <> 1 as the suppression condition. This technique works, but is very, very high maintenance - I now have these images at different group levels and in a number of reports.
Any ideas?
Cheers
g
I want a report to display one of 3 jpeg images, depending on the value of a field. I'd love to say something like the following in a formula:
if fieldA = 1 then jpeg1
else if fieldA =2 then jpeg2
else jpeg3
As a get around, I have the 3 jpeg images on top of each other in the report, with a formula in the suppression condition that controls whether or not that jpeg image is displayed. Eg, for jpeg1, I have fieldA <> 1 as the suppression condition. This technique works, but is very, very high maintenance - I now have these images at different group levels and in a number of reports.
Any ideas?
Cheers
g