Link to home
Start Free TrialLog in
Avatar of Seven price
Seven priceFlag for United States of America

asked on

crystal report shading

Does anyone know the syntex if i have an ID called Directs I want shading anything else no color.

example
if RecordNumber Mod 0 = 0 Then silver Else NoColor

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Seven price
Seven price
Flag of United States of America image

ASKER

getting error also when I input the syntex you provided I get the ID field highlighted and it says field not known.

Error in File  C:\WINDOWS\TEMP\temp_a1312633-eaf1-4fa9-a1e0-b62104b1863c.rpt: Error in formula  <Section_Back_Color>. 'If {ID} = 'Directs' then ' This field name is not  known. 

If {ID} = 'Directs' then
   crSilver
else
   crNoColor

Open in new window

Avatar of Seven price
Seven price
Flag of United States of America image

ASKER

never mind I know one sec
Avatar of Seven price
Seven price
Flag of United States of America image

ASKER

Ok I got that part. But what if I want just the text highlighted not the background?

If {item.ID} = 'Directs' then
   crSilver
else
   crNoColor

Open in new window

Avatar of Mike McCracken
Mike McCracken
Use the FORMULA BUTTON on the FONT page and change the color

mlmcc
Avatar of Seven price
Seven price
Flag of United States of America image

ASKER

No I already got it, But thanks for the reply.