Insert images in report

Dmitry shared this question 22 months ago
Answered

Hi All,

I have a requirement to display item images with other item information in a chart/report.


I found that it's possible to insert an image as a chart background, but is there a way to display item images from the urls in a report/chart?

Thank you

Comments (3)

photo
1

Hi Dmitry,

Yes columns can be formatted with HTML which means that if you source an image in an html statement, that image will replace the cell value:

15b944683037251689a14c5aadc6b2da

In order to do this you will need to disable the "remove HTML tags" option.

Let me know if this works for you.

Regards,

Nathan

photo
1

Hi Nathan,

Thank you for your reply.

We store images as URLs in our DB and connect to the DB directly from yellowfin instance.

Do I understand you correctly that it's not possible to simply insert image URLs and we will have to take one of the following steps:

1) create a rest API method, which will assemble HTML, which can be further used by yellowfin

2) modify the data in our DB to store HTML tags and then yellowfin will take this data from DB data sources


Thank you,

Dmitry

photo
1

Hi Dimitry,

If these URLs are already publicly, or at least locally, accessible, then all that should be necessary is to format this url to include the HTML tag, which could be done through a simple concat statement as a view level calculated field:

CONCAT('<img src="',url_field,'">')

Will this work in this case?

Regards,

Nathan

photo
1

Hi Nathan,

Thank you. This works.

However, I have another question:

Is that possible to display tooltips with image and some number on mouse over a column on a diagram(view)? The image will change based on the column, as each column will represent a particular item.

Thank you

photo
1

Hi Dmitry,

Glad to hear it!


At this point it is not possible to include non-text values into the tool-tip functionality, however I can see how this would be pretty cool, so I would recommend creating an "idea" topic to elaborate on exactly what you are looking for so that our product team can review it for possible inclusion.

Regards,

Nathan

photo
photo
1

I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!


Regards,

Nathan