Hyper link Nprinting HTML Report

[Pomna]

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>

[marcginqo]

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

[lironbaram · Accepted solution]

hi 

the cell with the link, should look like this 

<td><A href="%%='https://randomuser.me/api/portraits/men/' & floor(rand()*100)&'.jpg'%%">Link</A></td>

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

[Pomna]

Thanks but it does not work

[Lech_Miszkiewicz]

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.

[Pomna]

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.

<td><A href="%%Issue URL%%">Link</A></td>

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

Thanks Lironbaram.

[Pomna]

Thanks but Lironbaram's solution worked for me.