Skip to Content
0
May 25, 2016 at 02:56 PM

crystal reports background color formula

2012 Views

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