Formatting Group 1

[goduke]

Usually when I design a report I like to alternate the color of the rows so that it is easier to read. If my data is in the details I use:

if remainder(recordnumber,2) <> 0 then color(235,235,235) else white

If my data is in the group footer, I use:

if remainder(groupnumber,2) <> 0 then color(235,235,235) else white

However, the report that I have designed this time uses suppression in the group footer, based on a formula, which leaves my groupnumber count out of order. Is there a way to create a formula that will re-order the remaining groups that are not suppressed?

 

[lbass]

Create a formula like this:


whileprintingrecords;
numbervar grpno;
if not(<your suppression criteria here>) then
grpno := grpno + 1;

Add this to the group section and suppress it. Then your color formula should be:

whileprintingrecords;
numbervar grpno;
if remainder(grpno,2) <> 0 then
color(235,235,235) else
crwhite

-LB

 

[goduke]

Thanks lbass - that worked perfect. I was close but not close enough.