I have the following code;

=Nz([Transactions IN CASH].[Report]![Text38],0)+Nz([Transactions IN CHEQUE / ELECTRONIC].[Report]![Text38],0)

The two sources'text38 and text 38' are in two subreports.

The above code is to total the two values on the main report.

somtimes subreports have no data text38 will display #error if subreport is run individually. If main report is run and subreport have not data #error are not displayed.

Ive spent two day on this now I really need an answer.