Reports,Subreports & Expression Help

[denileigh]

I have an invoice report that contains 3 subreports (time, materials, detail).
In the footer of the report I have a the invoice summary which contains a field that calculates expenses based on the subreport. It has a control box in it with the following:

=[InvoiceSubReport].[Report]![Text19]

Text 19 is the total material cost from that subreport.

This works A-OK.

However, some jobs have time but no materials and when that happens that subreport completely disappears from the invoice report and that field generatea an #Error message and will not calculate properly. It also leaves a gap on the report where the subreport should be.

Is there anyway to have it defult to 0 if there are no materials? Is there a way to close the gap?

Is there a better solution?

Thanks!

 

[llkhoutx]

Try changing the 0 to Null and use the CanShrink property, it'll disappear.

 

[Rich]

search here for the HasData method

 

[denileigh]

Thanks so much!

Half the battle is learning what to search for isn't it?

*off to search the forums*