Background color on Altaernate Lines

[khan007]

I need to format some reports that have long lists of information and it would make them a lot easier to read if I could format the background color to alternate on every other line like in templates.
What would a sample formula for this look like?

I have found this formula on previous posting as:
IF Remainder (RecordNumber, 2) = 0 THEN Color (238, 238, 224) ELSE crNoColor

But my problem is, I am not displaying records from detail section in my report. I am displaying the totals calculated in my 3rd group footer. In this way above formula doesn’t fit with my requirements.

Please help me in this regard. I am on CR 8.5, Win 2K, SQL 2K.

 

[lbass]

Please see my last post in thread149-1073577.

-LB

 

[synapsevampire]

Try something like this:

booleanvar MyColor;
if MyColor = true then
MyColor := false
else
MyColor := True;
If MyColor = True then
rgb(blah,blah,blah)
else
If MyColor = True then
rgb(other,other,other)

Can't test right now but this should work...

-k

 

[khan007]

Thanks lbass.

It worked by creating a running total on group level, then use in color formula.

Thanks again.