#Error in report printing

  • Thread starter Thread starter Reji
  • Start date Start date
R

Reji

I designed a customer account satement report. In this
report for some customers there is no data for calcualtion
in certain period. So I am getting #Error as the value in
sum([Field]) fuction . I tried with Nz function to avoid
this problem, but not succeed. Is there any remedy for
this?

Thank you very much

Reji Eapen
 
Reji said:
I designed a customer account satement report. In this
report for some customers there is no data for calcualtion
in certain period. So I am getting #Error as the value in
sum([Field]) fuction . I tried with Nz function to avoid
this problem, but not succeed. Is there any remedy for
this?
Click to expand...


Check the report's (or subreport's?) HasData property.

=IIf(Report.HasData, Sum(amount), 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

Getting #Error on sum function in report 1
Printing #Err# on sum function in report 3
Calculations in a Report 3
Reports, Sub-reports running sum and no data 2
charts in Reports 1
Dlookup in reports 2
Help with #error in adding a field to a report 4
How do I print query parameters on the report? 2

Back
Top