Formula to Highlighting a field based on part description

[Former Member]

I have an existing report and I want to use a formula to highlight the product description in a different color by checking the the 1st char of the product code for the control break.

Is this possible and if so can someone show me the code ?

Many thanks

[abhilash_kumar · Accepted solution]

Hi John,

Right click the field > Format field > Font tab > click the formula button beside Color and use this code:

If {product code}[1] = 'x' then

CrBlue

Else CRNoColor

Replace product code with its field name and 'x' with the value you're evaluating it for.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

That worked perfect . Thanks

Is there also a way to evaluate several different codes  ?

eg,  Material code beginning with 9 = Red

Material code beginning with 6 = Blue

Everything else = Yellow

Thanks again

John

[abhilash_kumar · Accepted solution]

Yes:

select {Product Code}[1]

case '9' : crRed

case '6' : crBlue

Default: crYellow

-Abhilash

[Former Member · Accepted solution]

Abhilash,

That worked a treat - Thank you so much.

John