I have created a report which displays the excess inventory for a part number(it is a calculatrion of three fields), each part number can have several lines. I created a Group Band on Part Number, the calculation is set to sum and it resets after each change in part number. The problem is I don't want the lines to appear if the sum is '0'.
----------------------------------------------
i.e. xxxxxx pkg1 100
xxxxxx pkg2 50
----------------------------------------------
total xxxxxx 150
-----------------------------------------------
-----------------------------------------------
i.e. xxxxxxx pkg1 -100
xxxxxxx pkg2 25
-----------------------------------------------
total xxxxxx -75 I don't want this line to appear!!!
calculation set to 'sum'
What do you suggest?
----------------------------------------------
i.e. xxxxxx pkg1 100
xxxxxx pkg2 50
----------------------------------------------
total xxxxxx 150
-----------------------------------------------
-----------------------------------------------
i.e. xxxxxxx pkg1 -100
xxxxxxx pkg2 25
-----------------------------------------------
total xxxxxx -75 I don't want this line to appear!!!
calculation set to 'sum'
What do you suggest?