Using Highlighing Expert based on a string value.

[Former Member]

Attached is an example report that was not created by Crystal Reports.  I am working on re-creating it in Crystal Reports.

I am using Crystal Reports 2011.

I need to have only certain fields highlighted in yellow whose Serial No. starts with B.  How do I do that?

Sincerely,

Keith Jackson

[abhilash_kumar · Accepted solution]

Hi Keith,

Right-click the field > Format Field > Border tab > click the formula button beside 'background' and use this code:

if {serialnumber} startswith 'B' then crYellow

else crNoColor

-Abhilash

[Former Member · Accepted solution]

Thanks Abhilash!  That works perfectly.