Report #Error when summing and no records in subreport

[barrysprout]

I have a report that contains 2 subreports, each with a total field. I have a control on the main report that sums the totals from the 2 subreports.

This works fine when both subreports have records but if one subreport has 0 records, I get a #Error. I’ve tried using IsNull and IsEmpty to get round this, but neither work.

Any clues?

 

[Remou]

Hi
I think you need HasData:
[tt]=IIf([SubreportControlName].[Report].[HasData],[SubreportControlName].[Report].[TextBoxName],0)[/tt]