Using subreport total on main report

[stevemccauley]

I have a main report that lists customers and shows how much they have ordered. I also have a subreport for each customer that shows additional costs. I would like to be able to calculate the total ordered and additional cost by customer. How can I take a total from a subreport to add to a main report? Is this possible?

Thanks,
Steve

 

[Sohaila Taravati]

Yes, it is possible! Do this in the control source of a text box on your main report

[Reports]![YourSubreportName].[YourFieldonSubreport]

This should bring the value over from your subreport