topic Re: Qlik Nprinting in Qlik NPrinting

Qlik Nprinting

dhavalvyas — Tue, 23 Nov 2021 12:29:15 GMT

Hi hope all are doing good.

I have question on Nprinting HTML report.I have generated HTML report by taking image of Straight table and embedding the same in email body.

No . of records for that straight table may changes on daily basis, so either image cutted in case of records increases or lots of blank space left in case of records decreases.

I want to make it dynamically resizable, so it will automatically increase or decrease in size as per the records.

Re: Qlik Nprinting

Ruggero_Piccoli — Tue, 23 Nov 2021 16:03:35 GMT

Hi,

When creating new community questions, please, use a meaningful subject so people will easily understand if they can help you. Thanks.

I think the best solution is to export the Qlik Sense table as a table instead that as an image. As a table it will be exported with the correct number of rows without white space.

Best Regards,

Ruggero

Re: Qlik Nprinting

dhavalvyas — Wed, 24 Nov 2021 06:27:32 GMT

Thanks Ruggero for your suggestion.

However while i am exporting qliksense table for HTML report, it looks weird. It is not showing in proper format.

Also there is no rows and columns border showing in email body.

Please find image below for your reference.

Re: Qlik Nprinting

Lech_Miszkiewicz — Wed, 24 Nov 2021 06:52:20 GMT

You need to use inline formatting in your HTML to get right formats and also double check what sort of styling is supported in email clients you are sending your message to

https://www.campaignmonitor.com/css/

Re: Qlik Nprinting

Lech_Miszkiewicz — Wed, 24 Nov 2021 07:24:47 GMT

also check existing topics on that subject:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-HTML-Table/td-p/1749795

Re: Qlik Nprinting

Ruggero_Piccoli — Wed, 24 Nov 2021 10:27:09 GMT

Hi,

I agree with @Lech_Miszkiewicz , you have to customize the HTML code by adding style tags and checking the results with a third party tool that emulates different email clients. Qlik NPrinting supports the editing of the HTML code.

This is typical when creating HTML reports to be embedded into email bodies.

Best Regards,

Ruggero

Re: Qlik Nprinting

Lech_Miszkiewicz — Thu, 25 Nov 2021 01:26:25 GMT

Also regarding styling - here is an example i wrote. I know my example is for pivot table layout but you can get an idea how it needs to be done: https://nprintingadventures.com/2020/04/24/how-to-build-html-pivot-table-in-nprinting/

Re: Qlik Nprinting

dhavalvyas — Sat, 27 Nov 2021 11:21:11 GMT

Hi Lech_Miszkiewicz,

I have very simple straight table having only 5 dimensions and here i am giving only top 50 records data in straight table.

Need to build report in HTML similar to your suggestion in above thread.

Can you help me out how to embed all 4 columns within your code explained in above thread.

Attaching sample Screenshot here for your reference.

Thanks in advance.

Re: Qlik Nprinting

Ruggero_Piccoli — Mon, 29 Nov 2021 07:50:15 GMT

Hi,

About developing HTML reports, please start by studying https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/HTMLReports/IntroHTML.htm

create a Qlik Sense straight table with the columns you need and refresh the Qlik NPrinting connection data
create the HTML report with a native table that uses the Qlik Sense columns you need. Use the standard HTML <table> tag
customize the HTML style by using the standard HTML styling features
test the results by using a third party tool like the one suggested by @Lech_Miszkiewicz or by sending test reports on your email client. If needed modify the source HTML code. This is an interactive process because not all email clients render the HTML code at the same way. You have to check if your client needs some specific commands.

Best Regards,

Ruggero

Re: Qlik Nprinting

Lech_Miszkiewicz — Wed, 01 Dec 2021 10:03:11 GMT

Hi @dhavalvyas

I am not sure if you have found already an answer to your question, if not below are the steps I would do:

Create straight table in Qlik Sense, my table has only 3 values, but it does not matter in this case
Reload metadata in NPrinting,
- Open HTML template editor and
- bring in your table to "Tables" section in left panel.
- Disable "Keep Source Formats" for all columns.
- Drag & Drop columns you need to the template html script
- add <style> tags by typing required formatting - here i am using just basic ones
- I also added border ='2' in my <table> tag styling for border to appear
And the result in Outlook is like this:

hope that helps

cheers

Lech

Re: Qlik Nprinting

dhavalvyas — Wed, 01 Dec 2021 12:50:45 GMT

Hi @Lech_Miszkiewicz this perfectly works for me...Many Thanks

I have one more doubt I have 3 columns in my current straight table and suppose tomorrow there will be 5 columns...two more columns added to it...then how it will work ? Because currently we are dragging and dropping columns one by one within<tr>tag in HTML code.

In the attached file i have columns till Jul..once there will be more columns added to it for Aug,Sep,Oct....how it will work ?

Re: Qlik Nprinting

Lech_Miszkiewicz — Wed, 01 Dec 2021 14:13:06 GMT

for dynamic number of columns you may need to follow steps i have written in my blog post as that is the only way to maintain dynamic number of columns-just like pivot table.

cheers