Subreports

G

Guest

I have a unbound report that contains 4 subreports. Each subreport prints on
a new page with the use of page breaks. At times one or more of the
subreports may have no data, I can supress printing of the subreport in that
case but because of the page breaks I still get a blank page. Is there anyway
around this?
 
D

Duane Hookom

You can use code in the On Format event of the section containing the
subreport to make the page break control invisible if there is no data in
the subreport:

Me.pagebreak1.Visible = Me.subrpt1.Report.HasData
 
G

Guest

Thanks, that worked.

Duane Hookom said:
You can use code in the On Format event of the section containing the
subreport to make the page break control invisible if there is no data in
the subreport:

Me.pagebreak1.Visible = Me.subrpt1.Report.HasData
Click to expand...
 

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

Page breaks across subreports 1
Suppress hard page-break if no data? 4
Report with pivot tables and pivot charts in sub reports 6
Access How to prevent subReport from breaking across pages? 1
Subreports checkbox works but needs help with tweaking ! 1
Subreport with no records 8
Pagination of subreports 3
Subreports with blank pages 7

Top