Stopping blank pages

  • Thread starter Thread starter Diarmuid
  • Start date Start date
D

Diarmuid

Hi
Ok, I have a report with 8 sub reports. Lets call it rptHeader, with rptSub1
to rptSub8. This report goes to a Client.
Each report is to start on its own page, so on rptHeader, between each
report, I have a page break control.
However, sometimes one of the sub reports will be empty. Then a blank page
appears.
Is there a way round this? As in, I wish to remove the page break if the sub
report is empty.

Or, a thought just occured to me, I could remove all the page breaks, and
add a Client grouping to all the sub reports. Then turn on the Force New
Page property of the Client grouping.

Anyway, any advice appreciated.
Diarmuid
 
Diarmuid said:
Ok, I have a report with 8 sub reports. Lets call it rptHeader, with rptSub1
to rptSub8. This report goes to a Client.
Each report is to start on its own page, so on rptHeader, between each
report, I have a page break control.
However, sometimes one of the sub reports will be empty. Then a blank page
appears.
Is there a way round this? As in, I wish to remove the page break if the sub
report is empty.

Or, a thought just occured to me, I could remove all the page breaks, and
add a Client grouping to all the sub reports. Then turn on the Force New
Page property of the Client grouping.
Click to expand...


Add code to the Format event of the rptHeader section
containing the subreports:

Me.pgBreak1.Visible = rptSub1.Report.HasData
Me.pgBreak2.Visible = rptSub2.Report.HasData
. . .
 
Marshall Barton said:
Add code to the Format event of the rptHeader section
containing the subreports:

Me.pgBreak1.Visible = rptSub1.Report.HasData
Me.pgBreak2.Visible = rptSub2.Report.HasData
. . .
Click to expand...

Thats perfect, thanks!
Diarmuid
 
Back
Top