Link to home
Start Free TrialLog in
Avatar of Becky Edwards
Becky EdwardsFlag for United States of America

asked on

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.
Avatar of Mike McCracken
Mike McCracken

When do you want to alternate?

The group header only has 1 record

mlmcc
Avatar of Becky Edwards

ASKER

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.
Here is a sample of the report.
ExpExchSample.rpt
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Worked perfect!  Thanks!!!!!@