getting #error on my report

[calgary]

I'm getting #error on my report. This reports has 8 sub reports. And of course the sub reports are from different tables. How do I handle results that are 0? For example: Here's my calculation IIf(Sum([cost/lf]) > 0, Sum([cost/lf]),0) and this was done in expression builder.

What am I doing wrong?

Now this result is used in calculating other sub reports, so I need something that can be used multiple times getting to the final result.

Thanks!

 

[vbaInet]

You mean how do you handle when the subreport has no data?

 

[calgary]

Yes. What I have in my sub report now is the expression above.

Thanks!

 

[vbaInet]

Not quite the answer I was expecting.

So the #Error is showing on a textbox in the subreport?

 

[calgary]

Yes. So you think it's something other than my expression? I do know that for this sub report there is no data. But there is data for the other sub reports. And then at the end I have a total and it's not printing, so I have to be able to allow for nulls or zeros.

 

[vbaInet]

Can you upload your report in the next post?

 

[calgary]

Here's the database, has the report and query in it. The name of the sub report is Labour PCS sub report. And then the main report is Costing CS Report.

Thanks!

 

[calgary]

Not sure the database up loaded, sending again.

Thanks!

 

[vbaInet]

Sorry, I'm not seeing the #Error you're talking about. Did you test this database before posting?

Or can you tell the steps to reproduce this problem.