Selection based on running totals not zero

[65goatman]

I have a report that uses running totals based on a parameter field that looks at a formula field. These RTs are located in the group footers. If the RTs all have zeros, I do not want to display the individual group. How can I tell CR to suppress the group if all the RTs within the group equal zero? At this time, I see my group and the RTs all have zeros....

thanks!

 

[synapsevampire]

Right click the group and select format section.

Select the X2 next to the Suppress and enter your criteria, as in:

#RT1 = 0
and
#RT2 = 0
and...
etc.

Probably shouldn't use:

#RT1 +#Rt2 = 0

as one may have a negative and the other a positive which could equal out to 0.

-k

 

[65goatman]

Thanks, That seemed to do the trick for me....