Skip to Content

Web Intelligence - No Image return value

Nov 24, 2016 at 05:12 PM


avatar image


I have a report which will display images off a server depending on what is selected. If no image is found I don't want it to show a big red X rather a text field.

For example, depending on the country selected the flag of a country is displayed based on what is selected. The images are named based on the country e.g. UK.jpg. If for whatever reason the country image cannot be found I want it to display a text field e.g. "UK."

I am having difficulty in find out what is returned if an image cannot be found - all I see is red X. I have tried an if statement referring to another variable which shows a red X and seeing if whatever that returns details that the no image can be found but it doesn't work.

Any ideas?


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sai Prasad Nov 28, 2016 at 09:15 PM

Hi Leo,

If I understand your question correctly, here is my answer.Please try it and let me know.

Let say Country name field as Country and Image name field as Image.

Write a formula like below.

If([Image] is Null ;[Country] ;[Image])

Use this formula in the place of Image field.

10 |10000 characters needed characters left characters exceeded
Leo S Dec 01, 2016 at 10:28 AM

Hi, sorry this doesn't work. Any other ideas?

Effectively I guess I need to know what a cell where a red is displayed returns where the cell is set to an "image hyperlink"

10 |10000 characters needed characters left characters exceeded