cancel
Showing results for 
Search instead for 
Did you mean: 

crystal reports background color formula

0 Kudos

Hi,

I'm unable to get this working:

IF {Command.DESCR} like "TOTAL%" THEN crBlue else

if (RecordNumber mod 2 = 0 and NOT({Command.DESCR} like "TOTAL%")) then Color (233, 233, 255)

else crNoColor

What I'm trying to do is---

1. Have alternate coloring for rows---- very typical crystal reports style

2. any row for totals, I want to have background color as blue.

Some how above code misses the blue.

Any help appreciated!

Thanks!

Ankur

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Ankur,

Try:

IF {Command.DESCR} like "*TOTAL*" THEN crBlue else

if (RecordNumber mod 2 = 0 and NOT({Command.DESCR} like "*TOTAL*")) then Color (233, 233, 255)

else crNoColor

-Abhilash

0 Kudos

Great!!! Thanks Abhilash!! I was hoping you would come to the rescue, as I was right!! You made my day

Answers (0)