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
|