#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)
 
Back
Top