Sum Subreport Totals

[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

 

[Duane Hookom]

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