Solved

Alternating Roq Colours (with a catch)

Posted on 2011-03-14
2
319 Views
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
crwhite
else
crSilver

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)?
0
Comment
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
  • Learn & ask questions
2 Comments
 
LVL 26

Accepted Solution

by:
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

by:Clif
ID: 35132580
Perfect.

Thanks.
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

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 …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

630 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