Solved

Shade every other row in a report

Posted on 2004-09-21
4
549 Views
Last Modified: 2008-01-09
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
Comment
Question by:blouckswwu
  • 3
4 Comments
 
LVL 42

Accepted Solution

by:
frodoman earned 125 total points
ID: 12112149
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
 
LVL 42

Expert Comment

by:frodoman
ID: 12112165
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
 

Author Comment

by:blouckswwu
ID: 12112177
That worked perfectly.  Thanks frodoman.  Have a good day!
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12112246
Glad to help.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question