Subreports with no data

G

Guest

I have a main report with several subreports. The subreports each contain a
calculated field that I would then like to sum up on the main report. I keep
getting an error when a subreport contains no data. What coding can I include
in my calculation to account for this?

Lori
 
G

Guest

You haven't provided any mention of what expression you are currently using.
Generically you can use something like:
=IIf(subrptCtl.Report.HasData, subrptCtl.Report.txtTotal, 0)
 

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

SynNeed to account for null values in subreports 2
Using Subreports to create a Main Report 7
Page breaks across subreports 1
No Data on one of 6 Subreports 1
Supress printing of main report if all subreports have no data 1
Subreports Don't Display 5
Suppress hard page-break if no data? 4
Report with 2 Subreports 1

Top