Try this from BO's support site...
--------------------------------
1. In the database, enter the correct path to the file. For example, for PDF files:
Table 1 Table 2
Ben results\marketing\sales\reportben.pdf
Chris results\marketing\sales\reportchris.pdf
Dave results\marketing\sales\reportdave.pdf
2. Instead of the double-quote symbol ("), you must use the function CHAR(34). The number 34 is the ASCII code for the double-quote symbol.
3. Build a formula that will give you the correct HTML syntax:
<A HREF="\\servername\folder\folder\reportXX.pdf"> Value displayed</A>
For example, to display the PDF report based on the name object:
="<A HREF="+Char(34)+"path:\ "+(<link>)+Char(34)+">"+<Name>+ "</A>"
Where:
- "path:\" is the targeted server
- "<link>" is simple text pointing to the correct path for each value in database (i.e., "results\marketing\sales\reportben1.pdf")
- "<Name>" is the name in the database
For example, the result for the name object "Ben" will be:
=<A HREF="path:\results\marketing\sales\reportben.pdfl";> Ben</A>
The name will be displayed as a hyperlink in BusinessObjects.
Note: These hyperlinks will also work in WebIntelligence reports.
--------------------------------
A.