#error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Stefan,

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


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