Hide heading based on Data values

DavidEmerson

I have a column called Discount which shows the discounts for each data line.

If ALL (not some) of the lines have a zero discount then I would like to hide the group heading field as well as the data fields. How can I do this?

gordk

make the report a 2 pass report use a variable to get the sum of the field on the first pass
write code in the obp event of the header and master data band to hide the memoviews
on the second pass if the variable is > 0
ie if engine.finalpass memoviewname.visible = (var1 > 0);