Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 580
  • Last Modified:

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
0
blouckswwu
Asked:
blouckswwu
  • 3
1 Solution
 
frodomanCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now