Report / Subreport

N

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
 
D

Duane Hookom

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top