I have a report called Charges_Rpt that contain two subreports
SRpt_supplies
Srpt_services
each one of the subreport has total charges.
total_supplies
total_services
what I have the charges_rpt is a filed of grand total from both subreport. it works good when I have value in both sub reports but when one of them has blank data, the subreport does not show but the sum in the charge report would give me error
Grand_Total
Nz([Amount],0)
The above will return a zero whenver a field has no value.