Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Tan1
Partner - Contributor
Partner - Contributor
‎2022-12-01 01:07 AM

Inconsistent text font in HTML Report /Qlik NPrinting May 2021 SR3

Hi Team,

I have written the below code in Qlik NPrinting to generate HTML Report in the mail body.

<html>
<body>

<Table style="width:100%; Height:2000px; border=0.5px; border-style:solid; border-color:black;">

<tr style= "border: 1px solid black;">
<td style= "border: 1px solid black;" rowspan="3"> <img height="400" width="500" src="%%JwLQrhA%%" alt="JwLQrhA"></td>
<td style= "border: 1px solid black;text-align:center;"><img height="120" width="150" src="%%TSgfAv%%" alt="TSgfAv"> </td>
<td style= "border: 1px solid black;" rowspan="3"> <img height="400" width="500" src="%%GvVnu%%" alt="GvVnu"></td>
<td style= "border: 1px solid black;text-align:center;"><img height="120" width="150" src="%%MPgwQEm%%" alt="MPgwQEm"> </td>
</tr>

<tr>
<td style= "border: 1px solid black;text-align:center;"><img height="120" width="150" src="%%VTGqNP%%" alt="VTGqNP"></td>
<td style= "border: 1px solid black;text-align:center;"><img height="120" width="150" src="%%cQpkBs%%" alt="cQpkBs"></td>
</tr>

<tr>
<td style= "border: 1px solid black;text-align:center;""><img height="120" width="150" src="%%cRuHP%%" alt="cRuHP"></td>
<td style= "border: 1px solid black;text-align:center;"><img height="120" width="150" src="%%SfrLpdd%%" alt="SfrLpdd"></td>
</tr>

<tr>
<td style= "border: 1px solid black;" colspan="4"><img height="400" width="1500" src="%%YxSabmp%%" alt="YxSabmp"> </td>
</tr>

<tr>
<td style= "border: 1px solid black;" colspan="4"><img height="400" width="1500" src="%%ugeZyj%%" alt="ugeZyj"></td>
</tr>

<tr>
<td style= "border: 1px solid black;" colspan="4"><img height="400" width="1500" src="%%Mkmddy%%" alt="Mkmddy"></td>
</tr>

</table>

</body>
</html>

Problem statement - I am not getting consistent font style in all the charts when i trigger the report. every time it gets changed in Qlik NPrinting. In Qliksense dashboard, font style is consistent in all the charts.

image.pngimage.pngTan1_0-1669873955549.png

Please help me on this issue. I have attached the sample report for your reference.

NPrinting Version - Qlik NPrinting May 2021 SR3

Labels (1)
Labels
Daily Sales Cement NZ_2022-12-01T05-30-21-Z_Html.zip
499 Views
0 Likes
3 Replies
David_Friend
Support
Support
‎2022-12-01 02:58 PM

@Tan1 unfortunately I think that is the nature of HTML, if you want perfect consistency PDF would be the way to go, @Frank_S what are your thoughts?

473 Views
0 Likes
Frank_S
Support
Support
‎2022-12-02 03:59 PM

Try this...

https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/HTMLReports/HTML-formatting.htm

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
464 Views
0 Likes
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2022-12-02 06:44 PM

Well...

To me it looks like you are using images and text you are having issues with is also an image from Qlik Sense object which is having html responsive design meaning it adjusts itself depending on resolution and size of the image produced. None of the styles used in your code will have a effect apart from the size of the placeholder/image.

I NEVER use images unless it is the very last resort because of that very reason.

For most of the things you have there on the screen you could very much build proper html report with data being passed into HTML code and images used only for charts (not for chart titles,subtitles or footnotes as those scan also be done directly in html by passing formulas or variables or simply hardcoding them if there is no dynamic content.

Now, if you really need to use images you would have to play with those parameters which control resolution and size of the image: https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Image-Dimension-M... this is link to section of the help which @Frank_S has given you link to in his post.

HTML reports in nprinting require knowledge across Qlik, NPrinting, HTML/CSS also a mail clients support so there is a lot to consider when building such report. When done right it can get you stunning result but I agree it can be a painful process if you just starting with that template and you are not aware of all traps ahead of you - I have been there and I can understand the pain. I dont want to drag you away from the core of this conversation, but if you are interested you may as well have a read here where I describe how to use few tricks in HTML to get nice results in reports but also the let people realize how much prep is required to get it done:

https://nprintingadventures.com/2020/04/24/how-to-build-html-pivot-table-in-nprinting/

https://nprintingadventures.com/2021/06/22/js-charts-libraries-with-nprinting/

https://nprintingadventures.com/2019/05/24/creating-email-content-in-nprinting/

hope this 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.
459 Views
0 Likes