oracle-databasereporting-serviceshyperlinkoraclereports

Hyperlink in Oracle Reports (.RDF) Content using Oracle Report Builder

I am not sure if this is the correct forum to ask this question,

I am currently creating an oracle report (.RDF) using Oracle Report Builder and my client wants me to place hyperlinks in the content instead of putting URL in the content.

This report is going to be generated as PDF.

My current sentence looks like

Click here (http://international.usp.ac.fj/?page_id=114) to see USP member countries.

The URL automatically converts to hyperlink in the above sentence.

What my client wants:

Click here to see USP member countries.

I tried to look for an option where I can use HTML <a> tag.

I would like to know if there is a way to include hyperlinks in Oracle Reports.

Thanks

Solution

  • What you could in order to achieve this is, select property inspector of item you would like to have hyperlink and choose Hyperlink.

    enter image description here

    Also choose Yes for Contains HTML Tags.

    Format for passing dynamic values in URL is

    http://www.google.com?pid=&DEPTNO where DEPTNO is the value in report.

    Update

    This is what I did to achieve your expected output, you could modify based on your requirements

    enter image description here

    enter image description here

    enter image description here

    enter image description here

    Hope this helps.