Learn how to a build a cloud-first strategyRegister Now


Alternate Row Colors in Group Header

Posted on 2012-09-11
Medium Priority
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
  • 3
  • 2
LVL 101

Expert Comment

ID: 38387738
When do you want to alternate?

The group header only has 1 record


Author Comment

by:Becky Edwards
ID: 38388040
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
ID: 38388057
Here is a sample of the report.
LVL 101

Accepted Solution

mlmcc earned 900 total points
ID: 38388112
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
ID: 38388195
Worked perfect!  Thanks!!!!!@

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
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…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

810 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