sum field error

[JIM.H.]

Hello,
In my report I use Sum([fieldName]) to find the total in
my report. If there is no detail data listed this returns
error. How should I say show 0.
Thanks,
Jim.

 

[Marshall Barton]

In my report I use Sum([fieldName]) to find the total in
my report. If there is no detail data listed this returns
error. How should I say show 0.

Use the report's HasData property to check for that
situation:

=IIf(Report.HasData, Sum([fieldName]), 0)