Qlik Nprinting

[dhavalvyas]

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.

[Ruggero_Piccoli]

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

[dhavalvyas]

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.

[Lech_Miszkiewicz]

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/

[Lech_Miszkiewicz]

also check existing topics on that subject:

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

[Ruggero_Piccoli]

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

[Lech_Miszkiewicz]

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/

[dhavalvyas]

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.

[Ruggero_Piccoli]

Hi,

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

1. create a Qlik Sense straight table with the columns you need and refresh the Qlik NPrinting connection data
2. create the HTML report with a native table that uses the Qlik Sense columns you need. Use the standard HTML <table> tag
3. customize the HTML style by using the standard HTML styling features
4. 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

[Lech_Miszkiewicz]

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:

1. Create straight table in Qlik Sense, my table has only 3 values, but it does not matter in this case
   • 
2. 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 
   • 
3. And the result in Outlook is like this:
   • 

hope that helps

cheers

Lech