Color a field red

[psperry2]

I tried to put this formula in the 'Format Formula Editor: Font_Color' and I am not sure why it doesn't work. Basically I have got @RED set either to 1 or 0. So testing this I need a formula that will print the field in red and maybe italics also.


IF @RED THEN crRed
ELSE crnocolor

 

[lbass]

IF @RED = 1 THEN crRed
ELSE crnocolor

-LB

 

[psperry2]

That didn't work. I check the formula and get this message:
"A number, currency amount, boolean, date, time, date-time, or string is expected here"

I am using crystal 8.5

 

[lbass]

You need to show us the content of {@red}.

-LB

 

[AndyMc]

It might be that your 1 or 0 is a text field?
Try:

IF @RED = "1" THEN crRed
ELSE crnocolor

 

[Telemachus]

remove the quotes from @RED = "1" and try.

Use this:
IF @RED = 1 THEN crRed
ELSE crnocolor

Thanks,
Madhu

 

[psperry2]

This is the code that sets the @RED:

IF {BATCH.PAYMENTTYPE} IN ['VISA;VI','MC / Eurocard;MC','American Express;AE','Diners Club;DC'] AND
(ISNULL({BATCH.AUTHNUM}) OR {BATCH.AUTHNUM} = ' ' OR
{BATCH.AUTHNUM} IN ['CALL AUTH CENTER','DECLINED','Duplicate Trans','EXPIRED CARD','File Error','ConnErr',
'No Response','REFERRAL','User Not Found','CALL AUTH CENTER'] OR
{BATCH.AUTHNUM} LIKE '*Post Auth*' OR
{BATCH.AUTHNUM} LIKE '*CALL AUTH*' OR
{BATCH.AUTHNUM} LIKE '*PLEASE RETRY*')
THEN 1
ELSE 0

 

[lbass]

Can you verify that {@Red} does not generate an error and is giving the correct result if placed in the detail section?

-LB

 

[psperry2]

Yes I can. Right now there are no problems which would cause the @RED to be set to 1. It is always zero. There are no errors and the @RED field displays on the report.

 

[lbass]

Therefore the font color formula is working correctly also. If it isn't 1, it doesn't turn red.

-LB

 

[psperry2]

This is the formula that I get the error message:

IF @RED >0 THEN crRed ELSE crnocolor

error message:

The message is: A number, currency amount, boolean, date, time, date-time or string is expected here.

 

[spcc07]

Right click the field in the report.
<Format Field>
<Font>
Click the X-2 across from Color and type in
IF @RED = 1 THEN crRed
ELSE crnocolor

This worked for me.

SP

 

[lbass]

Where are you placing this formula? Where is the cursor when you get this message?

-LB

 

[psperry2]

Spcc07 I did as you suggested and still get the error when I click the check formula button.


lbass I put this formula in on the 'Format Formula Editor: Font_Color' Screen that you get when you do as Spcc07 specified.

 

[psperry2]

After much experimentation this works for me:

IIF({@RED}=1,crRed,crnocolor)

 

[psperry2]

So how would I do italics also then?

 

[lbass]

It makes no sense that the iif would work if the formula itself didn't.

To do italics, try the same thing in the font style area, substituting crItalics, and crRegular.

-LB

 

[psperry2]

Maybe the curly braces made it work

 

[lbass]

OHHHH!!! Yes, that would be it. You should just select the formula from the field list, and the curly braces will automatically be there. I didn't even notice that they weren't there.

-LB

 

[CoSpringsGuy]

WOW!!! LOL I have been following this thread trying to figure out what the heck?!?!?! I didnt even notice the {} either.

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection