Prev: blank subreports appearing on every record of report
Next: Report made of a query cross table
From: Barry on 1 Jun 2010 21:48
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
From: Marshall Barton on 1 Jun 2010 22:48
Barry wrote:
>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)

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: blank subreports appearing on every record of report
Next: Report made of a query cross table