Skip to Content
avatar image
Former Member

Web Intelligence - No Image return value

Hi,

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?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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"

    Add comment
    10|10000 characters needed characters exceeded