Alternate Row Colors in Group Header

Posted on 2012-09-11
Last Modified: 2012-09-11
I know there is a way to insert a colored text box and format the text box to alternate from grey to white, to grey to white, etc.  I just don't know what to put in the formula box under FILL to make it do that.

Can someone help?

I think it is something like

If {ado.x} <> {ado.y} Then
    Formula = crSilver'True    
    Formula = crWhite 'False
End if
  but I do not know what ado.x or ado.y is.
or should be.
Question by:Becky Edwards
    LVL 100

    Expert Comment

    When do you want to alternate?

    The group header only has 1 record


    Author Comment

    by:Becky Edwards
    I moved a whole bunch of stuff into the group header, so I want every other line in the group header to be gray, instead of white.  There is no detail line showing, just the group header.

    Author Comment

    by:Becky Edwards
    Here is a sample of the report.
    LVL 100

    Accepted Solution

    Like this one

    Here is the formula I used in the GH2 color formula

    Global NumberVar RowNum;
    RowNum := RowNum + 1;
    If RowNum MOD 2 = 0 then


    Author Closing Comment

    by:Becky Edwards
    Worked perfect!  Thanks!!!!!@

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    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 …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now