topic Re: Hyper link Nprinting HTML Report in Qlik NPrinting

Hyper link Nprinting HTML Report

Pomna — Wed, 08 Jul 2020 16:30:51 GMT

Hello I need to create an HTML report in NPrinting. The report is ok but the link does not work. Below is the code and the report but the links do not work. Any suggestions would be appreciated. Thanks.

<td%%=IF(Match([CusSat Rating],'1','2','3','4'),[CusSat Rating])//=([CusSat Rating])%%></td>
<td%%Issue URL_1%%></td>

Re: Hyper link Nprinting HTML Report

marcginqo — Wed, 08 Jul 2020 18:27:36 GMT

Hi @Pomna ,

If you go to the Report Editor and click on the field with the URL, left side of the screen where you see the tables.

On the bottom of the screen, where the properties are, there is an option to turn off HTML Encoding. Make sure it is turned off and try again.

Marc

Re: Hyper link Nprinting HTML Report

lironbaram — Wed, 08 Jul 2020 18:46:27 GMT

the cell with the link, should look like this

and make sure the in the table properties you uncheck the "keep source format" box

Re: Hyper link Nprinting HTML Report

Pomna — Wed, 08 Jul 2020 21:05:36 GMT

Thanks but it does not work

Re: Hyper link Nprinting HTML Report

Lech_Miszkiewicz — Wed, 08 Jul 2020 23:29:33 GMT

Hi @Pomna

@marcginqo is right about disabling HTML encode. The easiest way to debug it would be by inspecting what code is produced once you preview report, meaning:

Preview--> Open HTML--> right click and Inspect, that way you can see what is being created as your actual html code.

Re: Hyper link Nprinting HTML Report

Pomna — Thu, 09 Jul 2020 18:04:09 GMT

I got the solution. The link works now. I labelled the dimension with the link to the sheet in Qlik (see below).

Then in NPrinting, I used the HTML code below.

On the properties pane keep the Source Format check box unchecked and the HTML Encode check box checked.

Thanks Lironbaram.

Re: Hyper link Nprinting HTML Report

Pomna — Thu, 09 Jul 2020 18:06:52 GMT

Thanks but Lironbaram's solution worked for me.