I have a report which shows any month that has an open balance, per patient. So Group 1 is the patient, and Group 2 is the month. The details sections shows each charge or credit.

Details are suppressed if the entire month zeros out. In other words, if there is no open balance for the month, all transactions for the month are suppressed.

However a patient that has a zero balance should still show if he has any individual month with a balance. For example if January has a $500 balance and February has a ($500) balance so the patient has a zero balance, January and February data will still show and the patient header needs to show.

My problem is with suppressing the Group 1 Header -- Patient Header. I can't figure out how to suppress it based on whether there are any Group 2 groups (=months) with sum of transactions not zero.

I have tried quite a few things, but nothing is working. I have 15+ years of experience with CR but I am stumped! If anyone can take a stab at figuring this out or knows any solution I would be very grateful for your help.

thank you very much for your reply.
however, yes, my patient can have a credit in a month.
so that solution does not apply.