Display Images in Table

Adhoc
#1

Hello Helical Insight,

I am using Helical Insight 4.0. I want to display images against my client names in a tabular report. The image URLs are present in the database.

Thank You,
Jam.

#2

Hello Jam,

The datatable which we are using can understand HTML tags, so image tag can be used to display the same…You can use custom columns or database functions to display the images.

In order to display an image, the format should be as below:

<img src = “<image URL>” alt=”altTextForImage”> </img>

In order to achieve this, we can concatenate static text <img src=” before the image URL and “ alt=”altText”> </img> after the image URL.

If required, we can use altText also from the database column.

For this, we can use database function using the following steps:

  1. Drag the column containing the image URL on the report creation area.

  2. Go to More -> Advanced option. Select concat function for “text” datatype.

image

  1. Within the CONCAT function, add static text in the first section and in the second section, add another CONCAT function (nested).

In the first section of this CONCAT function, put the column with the image URL and in the second section put the trailing static text.
image

  1. Save the function and generate the report.

Alternatively, you can create a custom column with the CONCAT function.

Thank You,
Helical Insight.