Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Be original, if it means being a little eccentric, so be it
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Change the Font Colour of a Field based on a String it Contains in Crystal Reports 2008?

During a recent crystal reports 2008 consultancy project I was asked "How can I change the font colour of a field, if it contained a certain string within it?"


To achieve this on needs to use the Crystal Reports string function InStr.

The formula is as follows:

If InStr({Tablename.Fieldname},  "SearchString",1) <> 0 Then CrAqua Else CrNavy

The formula would be attached via the conditional formatting button of the Font Color option for the field

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

61 + 37 =