topic Re: NPrinting HTML Table in Qlik NPrinting

NPrinting HTML Table

Pomna — Tue, 06 Oct 2020 00:26:19 GMT

Please I need suggestions on how to fix this issue I have. I created an HTML table which am supposed to embedded in an email to send to the end user. The report creation and preview go hitch free but in the email the table structure that is the borders disappear. Any suggestions on how to fix this? Below is my code and screen shot of the table in preview and when embedded in an email. Thanks

<html>
<head>
<title>Table Example</title>
<style>
table {
border-collapse: collapse;
width: 100%;
}
th, td {
border: 1px solid grey;
padding: 10px;
}
</style>
</head>
<P style="font-family:Tahoma;font-size:48px"><P style="color:#000080;font-size:50px"align="center"><B> Demand Planning Negative Inventory Reporting </B></P></P>
<P style="font-size:14px;color:#000000"><B><P align="center">%%Report Date%%</P></B></P>
<body>
<table
<tr>

<th style="background-color:#6495ED"><P align="left">Depot Inventory Location ID</P></th>
<th style="background-color:#6495ED"><P align="left">Quantity</P></th>

</tr>
</thead>
<tbody>
<tr>
<td>%%ID%%</td>
<td>%%=Num(QUANTITY, '#,##0')%%</td>
</tr>
</tbody>

</table>

Re: NPrinting HTML Table

avinashelite — Tue, 06 Oct 2020 00:39:40 GMT

Try Changing the width to : 95% in outlook sometimes it gets disappeared and one more thing any specific reason your using the individual fields instead of the chart in Qlik as object/images because if you use the direct object it will take all the properties from Qlik object formatting

Re: NPrinting HTML Table

Lech_Miszkiewicz — Tue, 06 Oct 2020 01:26:23 GMT

There are few things very obvious to start with:

first - what goes to email is the content from <BODY> section of your HTML report so your STYLE tags are being removed hence they don't work.
second - the styles should be used inline directly in the table and you need to check which styles are supported in outlook or any other mail client. This is however outside of NPrinting and is purely html vs mail client issue.

Re: NPrinting HTML Table

Lech_Miszkiewicz — Tue, 06 Oct 2020 02:56:05 GMT

Hi @avinashelite

I vote against using images and whole object tags as this should only be used as a last possible solution. Other than simplicity it does not bring any extra value. The issue described by @Pomna is related to fact that mail clients are very fussy in regards to how they render html and the fact that only section from between <BODY></BODY> tags is making its way to html embedded report.

You should always check support of features used by reviewing css support using tools like: https://www.campaignmonitor.com/css/

Re: NPrinting HTML Table

avinashelite — Tue, 06 Oct 2020 03:58:40 GMT

thanks @Lech_Miszkiewicz , for updating me 😀....Generally I try to do most of the formatting in Qlik so easy to manage , Your rite !

Re: NPrinting HTML Table

Lech_Miszkiewicz — Tue, 06 Oct 2020 04:21:44 GMT

Hi @avinashelite

I agree that in general you would like to do as much as possible in Qlik, but format support is something what is hard to maintain in Qlik when you want it to be reflected in NPrinting. It also depends on the template you use and on the format you want to apply.

With QlikView it was little bit easier as we had non responsive design. Still many formatting features would not work (like colour transparencies or image transparencies) and would require different approach.

So as much as I can agree that it is simpler to do most in Qlik, I think it is not better (or even possible) when used with well formatted NPrinting reports

Re: NPrinting HTML Table

Ruggero_Piccoli — Tue, 06 Oct 2020 09:59:33 GMT

Hi,

The result could also depends on the email client you are using. So I suggest you to test your email with one of the online tools that will render it emulating many different email clients so you will see how it will appear.

Best Regards,

Ruggero