• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 866
  • Last Modified:

Alternate Row Colors in Group Header

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    
Else
    Formula = crWhite 'False
End if
  but I do not know what ado.x or ado.y is.
or should be.
0
Becky Edwards
Asked:
Becky Edwards
  • 3
  • 2
1 Solution
 
mlmccCommented:
When do you want to alternate?

The group header only has 1 record

mlmcc
0
 
Becky EdwardsEpic Clarity DeveloperAuthor Commented:
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.
0
 
Becky EdwardsEpic Clarity DeveloperAuthor Commented:
Here is a sample of the report.
ExpExchSample.rpt
0
 
mlmccCommented:
Like this one

Here is the formula I used in the GH2 color formula

WhilePrintingRecords;
Global NumberVar RowNum;
RowNum := RowNum + 1;
If RowNum MOD 2 = 0 then
   crSilver
Else
   crWhite

mlmcc
ExpExchSample-1-.rpt
0
 
Becky EdwardsEpic Clarity DeveloperAuthor Commented:
Worked perfect!  Thanks!!!!!@
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now