Skip to Content
0
Former Member
Dec 02, 2008 at 05:12 PM

Shaded lines

24 Views

I have a financial statement where I want everyother line shaded. The detail lines are being grouped and it is the group footer line that is printing. I am also suppressing the group footer if there is no data for the year. I have the following formula in the Color tab for the group footer:

WhilePrintingRecords;

NumberVar Counter1;

If remainder(counter1,2) = 0 then crNoColor else crSilver

The problem is when a line is being suppressed it is still being counted for the shading so I'm ending up with several lines together that are/are not shaded. How can I account for the lines that are being suppressed?

Thanks!