#error

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.
 
S

Steve Schapel

Stefan,

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SynNeed to account for null values in subreports 2
Errors in Report total fields 19
calculate when subrep has no records 2
Summing from a Subreport 3
Report Calculations 1
=iif Calculated field in report? 3
Calculating sums on values not in group 1
Report with no data? 3

Top