Section Format - Background Color: rows are all Black

[eao]

I am using a conditional formula to set my criteria. My default background is white, but if the formula is true, the I want the background to be silver. Here is the formula:

if (
{Work_Orders.Login ID Open By} = {Support_Staff.Login ID} AND
{Support_Staff.Sequence} = {Groups_Details.Seq.SupportStaff} AND
{Groups_Details.Seq.Group} = {Groups.Sequence} AND
{Groups.Code} = "NOTES_DEV"
)
then 1 
else 0

For some reason, all the records are formatted as black, even if I reverse the 0 and 1. Anyone have any thoughts? Thanks.

 

[chelseatech]

you need to use a color code value, not 1 or 0

then silver
else white // or nocolor is also okay. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm