#error in total when sub reports return no data

  • Thread starter Thread starter Don Seckler
  • Start date Start date
D

Don Seckler

I have a report which contains 4 subreports. There is a total field
in the footer that totals all the data from the subreports. When one
of the sub reports (Which are based on queries) return no data I get
an error in my total, but I still need the calculation to work and
print out.

Any Ideas how to get around this?
 
You can substitute a 0 for no data in a subreport with syntax like:
=IIf(subrptOne.Report.HasData, subrptOne.Report.txtTotal, 0)
 
Back
Top