SAP Knowledge Base Article - Public

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

Symptom

 How to customize the font of the field in a formula using Crystal Reports?

Environment

  • Crystal Reports 2008
  • Crystal Reports 2011

Resolution

  1. Create a report based on Xtreme Sample Database.
  2. Select the table Customer and Add a new Formula as Test.
  3. Add the fields to be displayed. For e.g.
        {Customer.Country} + ’ - ‘ + {Customer.Region}
  4. This will display the Country – Region in the report.
  5. To customize the Font of Region field alone add the code in the formula Test as follows:
         {Customer.Country} + ’ - ‘ + “ <b> <font color = ‘Red’ >” + {Customer.Region} + “ </b> </font>
  6. Drag the formula to the report. Right Click on the field. Select Paragraph tab.
  7. Under Text Interpretation drop down HTML Text.
  8. This will display Region in Bold and Red color.

See Also

http://scn.sap.com/thread/3229750

Keywords

Customize Font, Bold format. , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011