Subreports

S

spalj

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
 
S

spalj

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
 
Top