formula help for row suppress

[tttggg]

I have a summary report with 2 groups, City and customer.
Canadian cities have only one row for each itemid and US Cities has 2 rows for each itemid.
I need to suppress rows for the following conditions:
1.when the 2 discount values are zero (Canadian cities)
2.In US Cities both rows has to be suppressed only if discount 1 and discount 2 are both zero in both rows. for example In Detroit for Itemid 1125 Discount 2 is 12.00 ,therefore the those two rows should not be suppressed.
In Itemid 1158 both Discount values for both rows are Zero and therefore these 2 rows has to suppressed.



Toronto
item ID ref# Discount 1 Discount 2

1125 G5301 00.00 12.00
1158 G5309 00.00 00.00
5525 R5590 00.00 00.00

Detroit
item ID ref# Discount 1 Discount 2
1125 G5301 00.00 12.00
AA125 00.00 00.00
1158 G5309 00.00 00.00
AA558 00.00 00.00

Hopefully i believe that i explained my situation above, if you need any further explanation please post.
Working with CR 8.5 & DB2. Any help with this is much appreciated

 

[lbass]

Insert a group on city and a group on item and then go to report->selection formula->GROUP and enter:

sum({table.discount1},{table.item}) > 0 or
sum({table.discount2},{table.item}) > 0

This will work for both Canada and the US.

-LB