How to hide a data band when the running total of that band is zero
I have a report that shows a list of debtors with invoices sent to them and amounts paid.
For each debtor I show the amounts of all invoices and the amounts paid
GroupHeader: 'Debtor X'
Invoice 1: $100
GroupFooter : total: 0
GroupHeader: 'Debtor y'
Invoice 1: $200
GroupFooter : total: 150
Whenever the total equals '0' then I want to hide the entire block for that Debtor. So in the above case I want Debtor X to be hidden and Debtor Y to show.
My problem is that when the running Total is calculated I can no longer hide the current block
Is there a solution for this issue?