Total from 3 SubReports

[PearlGI]

I've have a report which contains 3 sub-reports and the totals from these sub-reports form the calculations appearing on the main report.

This works fine until one of the sub-reports returns no data. Then the calc on the main form returns an error as the control the calc is based on no longer appears on the report.

Any ideas as to how to get around this?

 

[Sohaila Taravati]

Use the Nz function on all of your subreports and that should solve your problem

 

[Rich]

You have to use the HasData method, NZ will not work on no records, search here for examples of the HasData method

 

[PearlGI]

Thanks Rich,

Now sorted.