• Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 10, 2021
  • Reading time:3 mins read
You are currently viewing How to add Hyperlink to the RTF template?
How to add Hyperlink to the RTF template?

In this article we will quickly look at how to add the hyperlink to the RTF template to get the output with hyperlinks (excel/pdf).

Normally when we insert the fields into the RTF template, they will appear as text by default. Even if the underlying data contains a hyperlink, they will be displayed as text.

First We need to insert the form field to the RTF template. We can use the Table Wizard or insert the field manually.

image 29 - How to add Hyperlink to the RTF template?

Once we added the field to the RTF, right click on the field and select link

image 30 - How to add Hyperlink to the RTF template?

Next, we need to add the code that will display the hyperlink

image 31 - How to add Hyperlink to the RTF template?

In the address box, we need to the add the XML tag name for email address or hyperlink field.

%7bPERSONAL_EMAIL_ADDRESS%7d

OR

{PERSONAL_EMAIL_ADDRESS}

and click OK.

The latest template will look like:

image 32 - How to add Hyperlink to the RTF template?

And sample output will look like:

image 33 - How to add Hyperlink to the RTF template?

On the output if we click on hyperlink, it will open up a default mailbox and tries to send an email. If there is an actual hyperlink, it will open up the URL on default browser.

If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.