Hyperlink open in a new window

[Eli]

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.

[MDXpressor]

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...

[Eli]

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!

[navissar]

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!  :)