I have a main report that shows invoiced sales by customer.  I want to show the orders on the same report.  I have created a sub report and linked the 2 and it works ok.

However I now want to add the 2 figures together so need a shared variable to pass to the main report(I think!).

What I end up with is a list of customers, showing the sales and the orders.

But when it gets to a customer with no orders it shows the orders from the previous customer and repeats this for all customers below until a new customer is reached with orders and then it  displays the new total.

If the customer below has no orders it repeats the same total again.

 

Please Help!

Your advice worked - why does it pick up the previous customer?

Thanks again.