Shade every other row in a report

Does anyone know how to shade every other row in Crystal Reports?  I was thinking that there is a formula to pick the even/odd records and put that formula in the background color formula section on the details section.

Thanks
blouckswwuAsked:
Who is Participating?
 
frodomanConnect With a Mentor Commented:
Report -> Section Expert.  Pick the section you want (details probably).  Click the color tab, then click the formula (X+2) button and enter this:

if remainder(recordnumber,2) = 0 then crWhite else crBlue;

frodoman
0
 
frodomanCommented:
Of course you can use whatever colors you want, it doesn't have to be white & blue.  You can also use crDefault to allow whatever color you've already set and you can use RGB(x,y,z) to specify a custom color.

frodoman
0
 
blouckswwuAuthor Commented:
That worked perfectly.  Thanks frodoman.  Have a good day!
0
 
frodomanCommented:
Glad to help.
0
All Courses

From novice to tech pro — start learning today.