SQL Server Performance

Combining totals from two sub reports?

Discussion in 'SQL Server Reporting Services' started by BrantE, Apr 6, 2004.

  1. BrantE New Member

    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.

Share This Page