Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Join us for live office hours! Q&A with Qlik on Dec 14 at 10am EST: Refining Reports and Visualizations
cancel
Showing results for 
Search instead for 
Did you mean: 
dhavalvyas
Contributor III
Contributor III

Qlik Nprinting

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.

 

 

Labels (2)
11 Replies
Ruggero_Piccoli
Employee
Employee

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



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
dhavalvyas
Contributor III
Contributor III
Author

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/

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Lech_Miszkiewicz

also check existing topics on that subject:

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

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Ruggero_Piccoli
Employee
Employee

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



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
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/

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
dhavalvyas
Contributor III
Contributor III
Author

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
Employee
Employee

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

 



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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
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
    • Lech_Miszkiewicz_0-1638348818037.png
  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 
    • Lech_Miszkiewicz_1-1638352560821.png

       

  3. And the result in Outlook is like this:
    • Lech_Miszkiewicz_2-1638352867684.png

       

hope that helps

cheers

Lech

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.