Calculating totals from subreports

[Guest]

I have created a report with multiple subreports. I need to calculate totals
from the sub reports and display the total in a text box on the main report.
Each sub report is based on a different query. Depending on the criteria
(Customer), occasionally some of the queries on which the sub reports are
based contain no records, because the customer will not have any records in
that query for that period. How can I perfom these calculations without
getting an error?

 

[Duane Hookom]

Use a control source on your main report like:
=IIf(subreportA.Report.HasData, subreportA.Report!txtTotal,0)
Of course, this will vary based on your subreport and control names.

 

[Guest]

I tried to use the following expression as the conrtol source for txtTotal:

=IIf([srptA].[Report].[HasData],[srptA].Report!txtInvBal,0)+([srptB.[Report].[HasData,[srptB].Report!txtInvBal,0)

srptB has no records. Rather than showing the value of txtInvBal, txtTotal
has no value at all. Am I using the correct syntax?

 

[Duane Hookom]

You have eight "[" and only six "]".

--
Duane Hookom
MS Access MVP

I tried to use the following expression as the conrtol source for txtTotal:

=IIf([srptA].[Report].[HasData],[srptA].Report!txtInvBal,0)+([srptB.[Report].[HasData,[srptB].Report!txtInvBal,0)

srptB has no records. Rather than showing the value of txtInvBal, txtTotal
has no value at all. Am I using the correct syntax?

Use a control source on your main report like:
=IIf(subreportA.Report.HasData, subreportA.Report!txtTotal,0)
Of course, this will vary based on your subreport and control names.