C
Chris
Hi there,
I have a report that contains 2 unbound subreports. Both subreports are
located in the report footer. 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.
In the OnFormat event of the report footer, I have used the following code
for each respective page break in order to get rid of the blank pages that
appear when the subreports do not contain any data, but I have also noticed
that even with some data in them, the subreports tend to have an extra blank
page!
Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Me.PageBreak45.Visible = Me.[Holding Letter: Green, Stage 2].Report.HasData
Me.PageBreak43.Visible = Me.[Findings Letter: Stage 1, Green].Report.HasData
End Sub
I don’t know what I am doing but I still get the blamk pages! I have also
looked on various forums, but there is nothing that seems to help me.
Please Help! Many Thanks,
Chris
I have a report that contains 2 unbound subreports. Both subreports are
located in the report footer. 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.
In the OnFormat event of the report footer, I have used the following code
for each respective page break in order to get rid of the blank pages that
appear when the subreports do not contain any data, but I have also noticed
that even with some data in them, the subreports tend to have an extra blank
page!
Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Me.PageBreak45.Visible = Me.[Holding Letter: Green, Stage 2].Report.HasData
Me.PageBreak43.Visible = Me.[Findings Letter: Stage 1, Green].Report.HasData
End Sub
I don’t know what I am doing but I still get the blamk pages! I have also
looked on various forums, but there is nothing that seems to help me.
Please Help! Many Thanks,
Chris