View Full Version : Using subreport total on main report


stevemccauley
08-20-2002, 06:40 AM
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
08-20-2002, 11:55 AM
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 :)