Subreports with no data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main report with several subreports. The subreports each contain a
calculated field that I would then like to sum up on the main report. I keep
getting an error when a subreport contains no data. What coding can I include
in my calculation to account for this?

Lori
 
You haven't provided any mention of what expression you are currently using.
Generically you can use something like:
=IIf(subrptCtl.Report.HasData, subrptCtl.Report.txtTotal, 0)
 
Back
Top