Creating a Hyperlink in Oracle reports



Description  The Hyperlink property is a URL link specification that displays a document or destination within a document when the object is clicked in the Web browser or PDF viewer.
Values  Any valid link to a:

·         destination within the current document (e.g., #my_dest_name)

·         destination within a local document (e.g., file:/private/somedoc.pdf#a_dest_name)

·         document on the local machine (e.g., file:/private/mynewdoc.pdf or file:///C|/temp/mynewdoc.pdf)

·         document on a remote machine (e.g., http://www.newmach.com/newdoc.pdf, http://www.newmach.com/newdoc.html, ftp://www.reposit.com/filetoget.example, http://www.somemch.com/cgi-bin/webmenu?choice1)

·         destination within a remote document (e.g., http://www.newmach.com/newdoc.pdf#some_dest_name)

Applies to  This property applies to layout objects
Default  blank
Usage Notes   
·         If a Hyperlink property is specified for a frame, the property will be transferred to all the child (interior) objects that do not have a Hyperlink property specified.  If the property cannot be transferred to the child objects, the frame's Hyperlink value is lost.
·         A report output in PDF format can include both hyperlinks and application command line links.  If the Application Command Line property is set for an object, it will be applied to the object.  Otherwise, the Hyperlink property is applied.
·         If a Hyperlink property is specified for an object in a frame, clicking the object will by default replace the frame with an entire window displaying the destination of the hyperlink.  To replace only the frame, include the following HTML in the Additional Hyperlink Attributes property setting:  target=filename, where filename is the name of frame to replace.

PL/SQL To define this attribute using PL/SQL, use the SRW.SET HYPERLINK procedure.