Make subreport show 0 count if no records available

D

Dee

I have a main report that has no query or links that
consists of 6 subreports (each subreport includes counts
of records from its individual source). This main report
is my "executive summary". However, when 1 of those
subreports has no records to show, it disappears and only
the rest of the subreports that have data are visible. I
want to make the subreport stay visible and show a 0 count
if no records are available instead of #ERROR.

Does anyone know how to do this, perhaps in programming
code in the VB module???

Thanks!

Dee
 

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

Hide subreport and main report record if subreport running sum is zero 9
blank subreports appearing on every record of report 0
Error in totals when no data in subreport 1
Subreport and Header Empty 1
Subreport Data Missing Inside Main Report 0
Subreport with no records 8
DB Documentation Report Crashes 0
Subreport label stays visible 4

Top