in the trial balance report, I want to omit the accounts that do not have any amount in the columns debit, credit or balance. with a new field i can do that the fields content not appears but even remains the empty space and I do not want it.
Also I have tried to do this checking the field "hide repetitive area when empty" but nothing happened.
i have this
debit credit balance
account 1
account 2 $1000
account 3 $1000
account 4
i need this
debit credit balance
account 2 $1000
account 3 $1000
what i can do.