topic Re: NPrinting report to show links correctly in Qlik NPrinting

NPrinting report to show links correctly

katrin_dobler — Mon, 13 Jul 2015 12:39:10 GMT

I've created a report with NPrinting showing all approved invoices in a given period.

As all our invoices are scanned and centrally stored the user should be able to click on the link to open the respective invoice.

The following picture shows the table in QlikView

This table is used for a NPrinting report, which is embedded as HTML in an email.

But the email shows the whole link as text. Some email clients are able to interpret it as a link, so it actually works for example with Outlook.

But it looks not really like a link...

Looking into the source with, I find the following:

My goal is, to show within the email only "Invoice" as text to click on to open the link.

Did anybody know how to prevent the translation from "<" to &lt?

Can anybody help with that?

Thanks

Katrin

Re: NPrinting report to show links correctly

Mon, 13 Jul 2015 16:58:11 GMT

I have run into a similar issue myself. The way I have gotten around the issue was to build a one line HTML report in NPringing, and the line in the report contains both the URL link and the description I want the user to see. You can then emebd the HTML report anywhaere in your email. see example

<A href="http//.........">Click Here for Details</A>

In the example above my URL link is between the double quotes. The description that the user sees is Click Here for Details

Re: NPrinting report to show links correctly

katrin_dobler — Tue, 14 Jul 2015 08:25:25 GMT

Hi Adam,

thanks for the reply. Unfortunately that does not work for me.

I forgot to say, that there is a table with several rows. And in each row an invoice is mentioned and at the end of each row the respective link should be shown as *Invoice* to click on.

Where do you define the link and what is to show? In the script of the QV app or in the Excel-Report of NPrinting?

Thanks

Katrin

Re: NPrinting report to show links correctly

Tue, 14 Jul 2015 12:10:18 GMT

I did not define the link in Excel but defined the link in a 1-line HTML NPrinting report.

standard HTML (I cut the link I wanted) and pasted the link into the html report, and after the link definition, I then put the description I wanted the user to see.

I then embedded the HTML report into the link

This method does not sound like it will work for you since my method had a static link that was part of the email message

You may want to try and use the Excel functionality of 'insert Hyperlink' within your Excel template (Insert menu, Hyperlink option

Re: NPrinting report to show links correctly

katrin_dobler — Tue, 14 Jul 2015 12:33:19 GMT

Ah. Ok.

But this is not possible for me, as I get the different links out of our ERP-system.

And it is a different link per line - as one line represents one invoice and also one specific link.

Any ideas?

Thanks

Katrin

Re: NPrinting report to show links correctly

Tue, 14 Jul 2015 12:38:44 GMT

one option to try (no guarantees) is to bring in the table into NPrinting. Drage the column from the NPrinting template side into a cell in Excel and then in excel use the Insert>Hyperlink on that column

Re: NPrinting report to show links correctly

lironbaram — Tue, 14 Jul 2015 14:25:04 GMT

try to build the report using pixel perfect reports

there you can define for each cell the url to open

i played with it a little bit and manage to create a report that each row is opening different web site

but for now i only managed to make it work at pdf and excel, for some reason it doesn't work properly in html

but i think this is something worth exploring

Re: NPrinting report to show links correctly

katrin_dobler — Tue, 14 Jul 2015 14:38:26 GMT

Unfortunately, that also does not work.

😞

Re: NPrinting report to show links correctly

Anonymous — Tue, 04 Aug 2015 02:48:12 GMT

So wanted to do the same, eventualy figured it out.

Rather then just adding in the table %%CH02%% etc

Create a schema like so

<table>

<tr>

<td>%%FIELDNAME%%</td>

<td>%%FIELDNAME2%%</td>

</tr>

</table>

when you expand the table in the left hand side you can pick each individual field individualy.

for the field with the link field in properties for that single field,

simply untick "keep source formats",

and untick " HTML ENCODE"

this will leave the HTML Code intact.

its abit annoying having to create the whole table schema but in the end it does what was required

(un ticking it and leaving the table in didn't seem to change the fact it was html encode in the overall table extract)

Re: NPrinting report to show links correctly

Sun, 08 Nov 2015 07:18:33 GMT

What joshua is suggesting works fine.

Thanks!

Re: NPrinting report to show links correctly

Frank_S — Mon, 09 Nov 2015 15:52:36 GMT

Joshua is correct.

Here is a tutorial associated with the solution he has suggested.

How to Apply HTML Formatting to NPrinting HTML Reports – Customer Feedback for Vizubi

Re: NPrinting report to show links correctly

katrin_dobler — Mon, 16 Nov 2015 09:00:14 GMT

Thanks a lot Joshua.

I'll try that.

Best

Re: NPrinting report to show links correctly

Tue, 26 Jan 2016 16:47:32 GMT

How do you get the links to stay as hyperlinks in the body of an email message. I get my data to come through in the format I need but when the email is created the hyperlink field is not interactive.

Re: NPrinting report to show links correctly

Andrea_Ghirardello — Wed, 27 Jan 2016 10:06:52 GMT

Hi, you can achieve this by configuring the QlikView Chart Expression as showed here:

Then, configure the tag in the Template as showed here:

Finally, insert in the email message in the task, the HTML report embed tag.

The email message you will receive will be something like this:

If you click on the links, the specific page configured in the QlikView chart expression will be opened.

Hope this helps.

Andrea