Blank page between two sub reports

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

I have this issue of showing blank page between two sub reports. I
have two sub reports in the report footer and if the first sub report
does not have any data it shows a blank page and then the shows the
data in the next sub report. Here is how it is setup

SubReport1

...... Page break

SubReport2

I do not want to take out the page break since i want the SubReport2
data to be shown on a new and seperate page.

Please let me know if there is any VBA codes that can solve my
problem.

Thanks
Moe
 
I have this issue of showing blank page between two sub reports. I
have two sub reports in the report footer and if the first sub report
does not have any data it shows a blank page and then the shows the
data in the next sub report. Here is how it is setup

SubReport1

..... Page break

SubReport2

I do not want to take out the page break since i want the SubReport2
data to be shown on a new and seperate page.

Please let me know if there is any VBA codes that can solve my
problem.

Thanks
Moe
Click to expand...

Got it taken care of, thanks
Here is the code in case someone else need it.

If Me.subreport1.Report.HasData = False Then
Me.rsubreport1.Report.Visible = False
PageBreak1.Visible = False
End If

thanks
 
Back
Top