Solved

Alternating Roq Colours (with a catch)

Posted on 2011-03-14
318 Views
I know how to alternate row colours with the following script in the conditional background:
``````if remainder(recordnumber,2) = 1 then
crwhite
else
crSilver
``````
However, with each group, it's a gamble as to whether or not the first record of that group will be white or silver.  Is there anyway I can make sure that the first row of a group always has a background of white (and alternates from that point)?
0
Question by:Clif
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 26

Accepted Solution

Kurt Reinhardt earned 500 total points
ID: 35132366
I generally create a running total in this case (using the running total wizard) that increments the count for each record in the group and resets the running total every time the group changes.

I then change the formula to something like:

if remainder({#RunningTotal,2) = 1 then
crwhite
else
crSilver

~Kurt
0

LVL 10

Author Closing Comment

ID: 35132580
Perfect.

Thanks.
0

Featured Post

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Simple Linear Regression
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Suggested Courses
Course of the Month3 days, 17 hours left to enroll