Perform Calculation on fields from Main Report and two Sub-Reports

[gopherking]

I have successfully performed calculations on fields that exist on a Main Report and also within the Report Header/Footer of a Sub-Report, but now I have a new challenge that I can't seem to get it right. I am in need of a calculation between a field on the Main Report, a field in the Report Footer of the 1st Sub-Report, and a field in the Report Detail of the 2nd Sub-Report.

Here is the basic equation that I am using in the Control Source of the field located in the Main Report - Report Footer section:

=Nz([JAN],0)-[1st_Sub_Report].[Report]![JAN Sum]-[2nd_Sub_Report].[Report]![JAN Sum]

[JAN] - Field on the Main Report in the Detail Section
[1st_Sub_Report].[Report]![JAN Sum] - Field on the 1st Sub-Report in the Report Footer Section
[2nd_Sub_Report].[Report]![JAN Sum] - Field on the 2nd Sub-Report in the Detail Section

I know that I can get the calculation to work if on the 2nd Sub-Report the field exists in the Report Footer, but the problem is that if there is no data in the Detail section of the Sub-Report, then it will not print (even the Footer).

Any thoughts on how I can get this to work, I would greatly appreciate it!

[pbaldy]

This thread is marked as solved. If it isn't, I often use this:

nnz function