Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Alternating Roq Colours (with a catch)

Posted on 2011-03-14
2
Medium Priority
?
323 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
2 Comments
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 2000 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] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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 …
Integration Management Part 2
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

571 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