Stopping blank pages

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
 
D

Diarmuid

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

Thats perfect, thanks!
Diarmuid
 
Top