Subreport with no data

[Dustin]

hello all
I am using a report to work out final costs. The report is based on a
querie that returns one calculated value, and then one subreport returns a
calculated value from another querie. The report then sums the first
calculated value with the value calculated and returned to the subreport.
The problem arises when the subreport returns no number, after that I just
get an error. Is there anyway to set the total from the subreport to zero if
there is no data, thereby just adding a zero to the total?

 

[Steve Schapel]

Dustin,

You can use the HasData property of the subreport, the equivalent of this...

IIf([NameOfSubreport].Report.HasData,[SubreportCalculatedValue],0)