Crystal Reports & SQL Reporting Services Training Consultants

Account Log in:

Username:

Password:

*Aim above morality. Be not simply good, be good for something* Henry David Thoreau

Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers

Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog

September

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?"

Solution:

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

3 Comments

Sky

October

What if I need to do two colors based on two search terms? If InStr({RMS_Object.Object_Description},"WS",1) <> 0 Then crRed If InStr({RMS_Object.Object_Description},"DV",1) <> 0 Then crBlue Else crBlack I tried connecting them by or but it wants a boolean... which, um, "OR" is. I thought.

Julia

October

There's a slight error in your formula. You're correct in using a nested IF statement: If InStr({RMS_Object.Object_Description},"WS",1) <> 0 Then crRed Else If InStr({RMS_Object.Object_Description},"DV",1) <> 0 Then crBlue Else crBlack

Julia

October

MAKE A COMMENT
Name *
Email Address *
Comment *
To prove you are human what is:
80 + 89 =

The Maximum Impact Solutions Blog

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

Sky

Julia

Julia

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

80 + 89 =