Main Report/ Sub Report Calculating No Data

[Ray67]

Hello

I have a main report and 3 sub report. When either of the sub reports have no data, my main report calculation returns an error. I have used the Nz in all of my controls. unfortunately this is not working.


=Nz([January],0)+N(R_consolidatedPersonalLoan2.Report.January,0 )+NZ(R_consolidatedRefund.Report.January,0)+NZ(R_c onsolidatedSecurity.Report.January,0)



Thank you

[pbaldy]

This should help:

nnz function

[Ray67]

Can you please elaborate? Where would i put this code on a report??

[pbaldy]

Like

=nnz(R_consolidatedPersonalLoan2.Report.January)

[Ray67]

Thank you that worked

[pbaldy]

No problem.