Font color formula

[junction123]

Hi,

I need help on a formula to hide the font, by changing the color to white to hide and black to display.

I tried the below formula in Crystal Syntax

IF {Detail.EqualizationCredit} = 'N' THEN CRWHITE
ELSE CRBLACK;

There are no errors but when I run the report, I get an error saying

"A number is required here" Error in formula.

Note that the field EqualizationCredit is a BIT with a value set to Y when 1 and a value set to N when 0.

Why is the report having an error when run?

Thanks for your help in advance. I need this urgently so any help is really appreciated.

Thanks

 

[DataDog]

So give it a number...
try changing your formula to read: "IF {Detail.EqualizationCredit} = 0 THEN CRWHITE
ELSE CRBLACK;"



DataDog
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?

 

[lbass]

Where are you creating this formula?

Did you test the formula by replacing 'N' with 0?

-LB