Subreports

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
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...
 
Back
Top