#error

S

Stefan

I am calculating a field which totals the sum of a report(Charges) and a
subreport(payments).

It works fine when there is data in the payment.

I get and #error which prints when there is no data in the payment
subreport.
What is the best why to have the payment subreport return 0(zero) if there
are no payments.
 
S

Steve Schapel

Stefan,

Use the HasData property of the subreport. For example...


=Sum([Charges])+IIf([YourSubreport].Report.HasData,[YourSubreport]![YourTotal],0)
 
Top