I have a report with several subreports. I have a subtotal sum on each subreport and on the main report an extended sum of all subtotals.
When the sum of a subreport's subtotal is null or = 0 (It displays 0.00), the extended total on the main report displays a "#Type" error, however if I simply click on the subreport that has that "0.00" value, then the error goes away and the extended sum is displayed correctly (it obviously does not add any value from that subtotal, which is "0" anyway).
I have added the Nz function to the subtotals and to the extended total to no avail. The extended sum just does not work under any circumstances until I click on the offending subreport.
I am baffled...
How can I fix this?
mafhobb
When the sum of a subreport's subtotal is null or = 0 (It displays 0.00), the extended total on the main report displays a "#Type" error, however if I simply click on the subreport that has that "0.00" value, then the error goes away and the extended sum is displayed correctly (it obviously does not add any value from that subtotal, which is "0" anyway).
I have added the Nz function to the subtotals and to the extended total to no avail. The extended sum just does not work under any circumstances until I click on the offending subreport.
I am baffled...
How can I fix this?
mafhobb