topic Re: Tabular reporting with Images in table cells in Reporting Service & Alerting

Tabular reporting with Images in table cells

joostvanegmond7 — Fri, 15 Nov 2024 20:56:22 GMT

I've created a table in Qlik Cloud with a column representing images from a URL. This works fine. But when I create a tabular report, refering to the created table, the images are not presented in the output of the report.

Is there are solution for this?

Re: Tabular reporting with Images in table cells

David_Friend — Thu, 31 Oct 2024 14:54:07 GMT

check that your images are following the limitations:
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Reporting-service-specifications-limitations.htm

I believe the specific image limitations are regarding their size?

Is it possible to share what your output does look like?

Re: Tabular reporting with Images in table cells

joostvanegmond7 — Fri, 01 Nov 2024 08:00:13 GMT

Thanks David for your quick reply.

I think I follow the image limitations. In the attachment you'll see the result of the demand report. The table itself had more than 1000 images in it, but I've select 1 article and the link is shown in stead of the image. In Qlik Cloud I can see the image in the table:

I've tried several image sizes.

Re: Tabular reporting with Images in table cells

Lech_Miszkiewicz — Fri, 01 Nov 2024 09:14:03 GMT

Hi @joostvanegmond7

You need to realize that what you are doing at the moment is "exporting data" table to excel and that is working as designed. This is the same process as going to Qlik Sense and choosing Download --> Data, which exports data content which is the url link of your image.

The only workaround for this is:

use of image (instead of table) when designing your report in Tabular reporting tempalte
use of other means of creating your report (combining levels and for example map objects with image as background) to create what you need.

The above will greatly depend on your actual report requirements thougg.

cheers

Re: Tabular reporting with Images in table cells

joostvanegmond7 — Mon, 04 Nov 2024 07:44:10 GMT

Hi Lech,

Thanks. The workaround does not mee my requirements. I want a multipage report in pdf with on each row an image. It works with going to Qlik Sense choosing Download -> PDF, but then I get just one page. I hoped the PDF output functionality of the tabular reporting does the trick.

I think I should wait for the Pixel Perfect reporting functionality which should be delivered this year.

Joost

Re: Tabular reporting with Images in table cells

Lech_Miszkiewicz — Mon, 04 Nov 2024 11:54:23 GMT

Hi @joostvanegmond7

I dont see a reason why pixel perfect reporting would work better than excel tabular reporting. Yes, you will be able to get dynamic image in it, but principles will work the same as in tabular reporting so I dont know as to why that would make a difference?

In fact I am actually in a process of testing pixel perfect reporting for Qlik Sense SaaS and I think there is really no difference in how you would need to go about it (using a level in order to loop through each individual value of the table) - the same as per this instruction from NPrinting Pixel Perfect: https://community.qlik.com/t5/Official-Support-Articles/How-to-add-dynamic-images-in-a-Qlik-NPrinting-PixelPerfect/ta-p/1614723

If you do that in excel add-in tabular reporting you could then nest image from map object on each value of the level (note that your table can be added as a level as well as long as it does not contain calcualted dimensions!).

Out of curiosity, When you say it is multi page report - are we talking hundreds or thounds of pages or rather small number <100 pages?

cheers

Re: Tabular reporting with Images in table cells

joostvanegmond7 — Mon, 04 Nov 2024 13:18:33 GMT

Hi Lech, Thanks four your reply. Maybe I'll do some testing with adding an image on each table row. The multipage reports are just around 10 pages or so. These reports consists just one big table with one each tablerow an image.

Regards, Joost

Re: Tabular reporting with Images in table cells

Lech_Miszkiewicz — Tue, 05 Nov 2024 02:16:43 GMT

Hi @joostvanegmond7

I just tested it and as I said earlier - it works.

I have created table with all the data I need
I have created map object with image as a background
I created a report using excel add-in and used my table as a level and put map object as an image inside that level
Run preview and voila

1. Level constructed from my table

2. Data from the level

3. Image from the map object

Preview:

cheers