1487771 - How to add hyperlink in a text in Crystal Reports using HTML Text Interpretation?

SAP Knowledge Base Article - Public

1487771 - How to add hyperlink in a text in Crystal Reports using HTML Text Interpretation?

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 - Service Pack 3 and above
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

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:
         
    1. In Crystal Reports, create a report off any data source.
          
    2. 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.
            
    3. Insert the Formula Field on the report.
        
    4. Right click on the "Formula Field" inserted on the report, and select "Format Field"
       
    5. In the "Format Editor" window, select the tab "Paragraph"
         
    6. For the option "Text Interpretation", select "HTML Text"
        
         HTML Text.png    
           
        
    7. 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 BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016