How to avoid error when sub report doesn't return any rows 1

[sjh]

Hi, I have a main report which has two sub reports. In the report footer, I have a row which sums up the total from the two sub reports.

Record Source Property
=rsubConstruction.Report!txtSum1+rsubCapital.Report!txtSum1

But if any of the sub report doesn't return any data, it prints out "#ERROR".

Is there a way to avoid this from happening?

Thank you!!!!

SJH

 

[THWatson]

SJH
Take a look at the HasData property.

For example, here is an expression for a text box
=IIf([YourSubReport].[Report].[HasData]=-1,[YourSubReport].[Report]![txtBox],0)


Tom