Conditionally formatting font color 1

[runnerlk]

I have the following formula to change the font color to red. It appears that values that are equal are also red.

This is an SQL v2000 database with an ODBC connection

If Sum ({@CurrentMonth})>Sum ({@CurrentMonthPriorYear})Then crRed
else crBlack

All of the values are currently single digit.

So for instance if both columns are 0 then the {@CurrentMonth} is red s/b black.

Any insight would be appreciated.

Lou

 

[chelseatech]

Sum({Field}) does a grand total, so you will get the same result for all the records in your report.

Use Sum({field},{groupfield}) instead.

Editor and Publisher of Crystal Clear

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