Hi all,

I have a report calculating the commission per client. This is done within a certain date range in which the customers paid the bill. In a subreport, I then calculate the costs made for these bills. This is done on a the same date range, but on a different field.

Problem I am having, is that it is possible that there are costs made on a case, but here hasn't been any payments yet. So on the main report the customer doesn't show yet, but in the subreport it does.

I pass the costs with a shared variable. But when I want to pass the total amount, it doesn't match with the figures already shown on the current report.

And when I link the subreport on customer Id or Invoice Id, The total is always 0.

Can anyone help me with this?

Thanks in advance.

Kind regards,

Gerben

Not exactly. are only a handfull of clients with costs, but loads of clients with payments. It isn't necessary however, that there are payments if a client has any costs. So if I would switch the report around, Wouldn't I only get the clients where there are costs involved?

Edited by Gurbs - 14 May 2012 at 10:15pm

Try resetting your TotalOther to zero in the report header of the subreport.  This should return zero when there are no costs.