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
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?
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
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
So wanted to do the same, eventualy figured it out.
Rather then just adding in the table %%CH02%% etc
Create a schema like so
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)
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.