Report/Subreport

J

John

Calculated totals on my report work properly as long as the subreport has a
value or a related record. However when there are no values or no related
records in the subreport, I get a #ERROR.

How can I get the calculated total to treat no values or related records as
zero and return zero or the value from the main report and avoid the #ERROR?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error in totals when no data in subreport 1
SynNeed to account for null values in subreports 2
blank subreports appearing on every record of report 0
Hide subreport and main report record if subreport running sum is zero 9
Report with 2 Subreports 1
Subreport doesn't work with a query 0
Subreport Data Missing Inside Main Report 0
Return Totals for multiple categories from a subreport 4

Top