SQL Server Performance Forum – Threads Archive

Combining totals from two sub reports?

Does anyone know how to combine totals from two sub reports into one total on the main report? Eg. I have a main report which lists the project details of many projects, where for each project there is a sub report for salary costs, then another sub report for all other expenses. I would like a total at the bottom of the sub reports for each project which adds these two amounts together, but I can’t find a way to get this information out of the sub reports. Any ideas? Help is much appreciated.

---

]]>