Summing Two SubReports

[CCIDBMNG]

I have two subreports on one report. One subreport shows hours worked on-site for a month period broken down by week. The other subreport shows hours worked in-house for a month period broken down by week. On the main report I want to show total hours worked broken down by week.

I tried creating hidden running sum text boxes on the subreports that say if week=week1 then count hours else 0. This works great on the subreport but when I set a text box on the main report equal to these text boxes only week 1 hours show, I've checked my spelling everything is right. It doesn't even give me an error it just gives me a 0. Does anyone know why this is or another way for me to do this.

There's a few crazy formulas that also show on the reports so I don't want use a query to do it unless I have to because the query could be very complicated to pull both toghether.

 

[ThreeCrow]

On your report just below your second subReport, place a text box.

For its' recordsource use the Expression Builder to bring these two figures together.

=[subReport1].[Worked1]+[subReport2].[Worked2]

Hope this Helps