I try to create hyperlinks that will open in a new window when it is clicked.
I am able to create the link using HTML that opens in a new window
like most people suggested when I search the web. However, when the report is exported to EXCEL or PDF the HTML
links are not shown in the report at all.
Now I have to resolve either one of the problems:
- Hyperlink in report that will open in a new window when it is clicked
- HTML link that will work in PDF or EXCEL.
Please help.
Thanks.
I don't think hyperlinks will export to excel. Hard stop.
As for PDF, I know you can export bookmarks, which have active links, so I think you should also be able to export regular hyperlinks. I'll do some meandering, and get back to you...
Hyperlinks do work in EXCEL/HTML/PDF report. However, hyperlinks alway open in the same window as the report.
That's why I switch to use HTML which I can make it to open a new window like this:
<a href="[Query1].[urllink]" target="_blank"> [Query1].[Last Name] </a>
However, when I export the report to EXCEL or PDF, the column with the HTML links do not show anything at all.
So now I am back to use hyperlinks but to try to see if I can make the link open in new window.
Or if someone know how to make HTML link work in PDF or EXCEL report, it is great too!
I most certainly agree: If anyone ever came up with a way to use HTML in a PDF or Excel file, that would be super! :)