Report / Subreport

[nathan sanders]

Hi,

I have a report (Invoice) which has two subreports in the detail section.

I calculate the total value of records in both subreports in the footer of
the main report to give an Invoice Total.

All works perfectly....... Until

There are no records to report in one of the subreports... then it all goes
haywire and I get an #ERROR as my total.

How do I overcome this issue please?

Nathan

 

[Duane Hookom]

You can use an expression like:
=IIf(subrpt.Report.HasData, subrpt.Report.ControlName,0)

 

[nathan sanders]

Duane,

Thanks....

This was the perfect answer.

Regards
Nathan