Error in totals when no data in subreport

[Barry]

Good Evening:
I have a report ("Invoice") which has 2 subreports, one for parts and the
other for labor. When either has no data the calculations for totals on the
main report show #error. I am having difficulty making the data from the
offending subreport zero (0). Any ideas as to how to force the situation
when no data exists in the particular subreport? Thanks much for reading
this.

Barry

 

[Marshall Barton]

I have a report ("Invoice") which has 2 subreports, one for parts and the
other for labor. When either has no data the calculations for totals on the
main report show #error. I am having difficulty making the data from the
offending subreport zero (0). Any ideas as to how to force the situation
when no data exists in the particular subreport?

The grand total calculation should use this kind of
expression:

=IIf(subreport1.HasData, subreport1.Report.total1, 0)
+ IIf(subreport2.HasData, subreport2.Report.total2, 0)