topic Re: Nprinting Straight table with image in Qlik NPrinting

Nprinting Straight table with image

Anonymous — Wed, 25 Sep 2019 18:40:54 GMT

Hi community,

I'm attempting to create an HTML report using Nprinting. Most of it works fine, but when trying to Nprint a straight table that contains an image, the report will not display the image.

This is the table I am attempting to produce in HTML:

The 'Competitor' column contains an image for each dimension (the actual dimension column is hidden).

However, this is the result when this table is placed into my email report through nprinting:

The competitor field seems to have dropped off, and I'm not sure why.

For reference, here is my HTML code:

Thanks,

Henry

Re: Nprinting Straight table with image

devarasu07 — Mon, 23 Oct 2017 14:56:10 GMT

Hi,

Another method:

Nprint excel report - by creating levels option you can able to achieve it

refer to the mock

Repeat Column header in Qlik Nprint 16.3

Add external images into and Excel report

PS:

Thanks,

Deva

Re: Nprinting Straight table with image

Anonymous — Tue, 24 Oct 2017 08:50:34 GMT

Hi Dev,

Thanks for the thread - interesting read.

However, my business requirement is that the report is rendered as HTML, as it is embedded in an email that is sent out to multiple recipients. Like this:

Graphs work great, it's just tables that aren't behaving. It is possible for me to paste the table in as an image, but that means loosing functionality.

Re: Nprinting Straight table with image

Anil_Babu_Samineni — Tue, 24 Oct 2017 10:21:54 GMT

I never used, nprinting. But, in html code do you used correct path path of image. Can you copy image section of div to notepad and use this chrome to open that file and check whether the image is coming up or not.

Re: Nprinting Straight table with image

Anonymous — Tue, 24 Oct 2017 12:15:23 GMT

Ah, very good point! These images are on my local directory, so they cannot be displayed on a browser.

I've tried testing it with an image I uploaded to imgur, but the images are still not displaying. I've checked that the file path is correct, as the <img src = "link"> tag does work on the file.

Re: Nprinting Straight table with image

RonaldDoes — Tue, 24 Oct 2017 12:25:34 GMT

Hi Henry,

I circumvented a similar issue by manually uploading the images to the webserver the HTML-reports are pushed to and just referencing them in the report.

This would of course need to be accessible to al receipients of your email.

With kind regards,

Ronald

Re: Nprinting Straight table with image

Anil_Babu_Samineni — Tue, 24 Oct 2017 13:07:09 GMT

Great, you liked it !!

And id nprinting supports then I believe it should work. Can you give absolute path using directory like ../../../filename.png... then we can look the part where it is not working..

Re: Nprinting Straight table with image

Anonymous — Tue, 24 Oct 2017 13:51:37 GMT

This is the absolute file path, and should populate the cell on the top right, under the header "TP Image". In Qlik, the cell is represented as an image (which does work).

https://travisperkins.scene7.com/is/image/travisperkins/K0661_287611_00?defaultImage=travisperkins/missing-product&layer…

The result is this, though:

Re: Nprinting Straight table with image

Ruggero_Piccoli — Tue, 24 Oct 2017 14:54:37 GMT

Please note that you can embed HTML reports into email bodies in Qlik NPrintin 16.*. This feature will be supported in Qlik NPrinting 17 starting from next release November 2017 (17.5.0).

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Nprinting Straight table with image

Daniel_Jenkins — Tue, 24 Oct 2017 21:41:56 GMT

Hi Henry,

Just so you know, many report types allow you to specify an alternate format for the final report. So, you can build an Excel report (as in the examples linked to above) and specify the final format to be HTML - and embed that into the body of your e-mail message (currently available only in version 16).

HTH - Daniel.

Re: Nprinting Straight table with image

Anil_Babu_Samineni — Wed, 25 Oct 2017 05:40:33 GMT

Can you share the settings of Image report and/or object? So then i may get some idea..

Re: Nprinting Straight table with image

Ruggero_Piccoli — Wed, 25 Oct 2017 09:16:00 GMT

I marked this as correct because the steps in the article Add external images into and Excel report works also for HTML reports. Just follow it.