How to create green bar report in Drill Down Report

[uticket]

Hi, I used following codes to create green bars on the report for easier reading.

If Remainder(RecordNumber, 2) = 1 Then
Color(222, 251, 164)
else
Color(240, 254, 214);

However, it does not work for drill down reports, as it seems the report also count the recordnumber of the drill down tables(though they are not appear).
Anything we can do to fix the report?

Thanks!

 

[bdreed35]

Create a running total that counts one of your detail fields, evaluates each record, and resets on change of your lowest group.

After you create it, reference the Running Total in your above formula rather than the recordnumber function.

If Remainder({#RTRecordNumber, 2) = 1 Then
Color(222, 251, 164)
else
Color(240, 254, 214);

~Brian

 

[uticket]

Cool! Thanks for your help.
Lots of big cows on this board.