Stopping blank pages

[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

 

[Marshall Barton]

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.

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
. . .

 

[Diarmuid]

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
. . .

Thats perfect, thanks!
Diarmuid