Sum Subreport Totals

  • Thread starter Thread starter HollyH
  • Start date Start date
H

HollyH

I have a report that draws in two subreports.

Hours Subreport
Expenses Subreport

I need to get the totals of these two subreports and add
them together. One field has the possibility of being null.

=[Itemization Subform].Report![ItemizedExt] is the totaling
field for the Hours Subreport

=IIf([Itemized Expense
Sub].Report![ReimbursableExt]=Null,"0",[Itemized Expense
Sub].Report![ReimbursableExt]) Is what I am trying to use
for the Expenses Subreport.

The report runs fine if I have expenses, but if I don't
have any Expense entries, I get an error.

Please help
 
Try:
=IIf([Itemized Expense Sub].Report.HasData,[Itemized Expense
Sub].Report![ReimbursableExt],0)
 
Back
Top