Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hyperlink to Powerpoint file

Status
Not open for further replies.

mpandui

Technical User
Nov 30, 2003
7
I am trying to create a hyperlink within a FC report to a Powerpoint file (located on a shared network drive). I was able to create hyperlink to .htm file, but doesn't seem to work with powerpoint file?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top