Alternating Roq Colours (with a catch)

Posted on 2011-03-14
Last Modified: 2012-05-11
I know how to alternate row colours with the following script in the conditional background:
if remainder(recordnumber,2) = 1 then

Open in new window

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)?
Question by:Clif
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
  • Learn & ask questions
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

LVL 10

Author Closing Comment

ID: 35132580


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

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 …
In an interesting question ( 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…

751 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