Hi, I am doing a report which seems quite simple, and I know i have used sharing between reports and sub reports, but it has been a while.

I am trying to write a report that will print accounts receivable statements. I do not want any zero balance invoices to show.

so if in the detail, i have something like this:
Invoice #
244567      invoice   $5.00
244567      payment   $5.00
which leaves the balance of this invoice at zero.

I am grouping by Invoice number. I cannot use the total to suppress the section, because the total is not yet known when it is printing the detail.

so i thought very simple, i will write a sub-report to get the total, then pass it back to the main report to use to suppress zero invoice sections.

I cannot get it to work.   I have tried various combinations. Does anyone have any idea how i could do this ?   simple explanation if possible, i am not real advanced in Crystal.

Thanks!

Hi Lockwelle and thanks for your reply. That is what i tried, and it's not working for some reason :( i also tried suppressing the group header if that field is zero, and it suppresses everything and just gives me the report total... any idea why this would not be working?