Symptom
- How to add hyperlink?
- In Crystal Reports, how to add in a middle of a text a hyperlink to a website?
- How to add a hyperlink in Crystal Reports when using HTML Text Interpretation?
Environment
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Resolution
- In Crystal Reports, it is possible to format text using HTML Tags, and from Service Pack 03 of Crystal Reports 2008 and above, it is possible to add hyperlink in the middle of a text using the HTML tag <a>. Below are the general steps on how to add a hyperlink using the HTML tag <a> in Crystal Reports:
- In Crystal Reports, create a report off any data source.
- Create a Formula and type the desired text and hyperlink using the HTML tag <a> like:
'My Hyperlink to: <a href="www.sap.com">SAP Hyperlink</a>'
Note: The above example create a hyperlink to the SAP website.
- Insert the Formula Field on the report.
- Right click on the "Formula Field" inserted on the report, and select "Format Field"
- In the "Format Editor" window, select the tab "Paragraph"
- For the option "Text Interpretation", select "HTML Text"
- Click "OK"
Now, when viewing the report, it will display a hyperlink for the field.
For a list of supported HTML Tags for the HTML Text Interpretation option in Crystal Reports, as well as a sample report, see the following SAP Knowledge Base Article:
1217084 - What are the supported HTML tags and attributes for the HTML Text Interpretation in Crystal Reports?
Keywords
What's new, upgrade, hyperlink, URL, CR hyperlink , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020