1767158 - How to change the font color of a field in a formula in Crystal Reports?

• How to dynamically change the font color of a field?
• How to customize the font color of the field in a formula using Crystal Reports?

• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
• SAP Crystal Reports 2025

• To change the font color of a field dynamically in Crystal Reports, create a formula, and use HTML tags.

1. 1. In Crystal Reports, create a report based on any data source.
         
   2. To customize the Font color for a database field, create a formula using HTML tags, like:
      
           <Database Field> + ’ - ‘ + “ <b> <font color = ‘Red’ >” + <Second Database Field> + “ </b> </font>
      
      
   3. Add the formula to the report.
        
   4. Right click on the formula field, and select "Format Field"
      
      
   5. In the Format Editor, under the tab Paragraph, for the option "Text Interpretation", select: "HTML Text"
        
   6. Click "OK"

Customize Font, Bold format. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025