Blank page if sub report has no data

D

deb

I have a report with 3 sub reports.
When one of the sub reports has no data it creates a blank page.
I have the margins formatted corectly. It only creates a blank if the sub
report has no data.

Is there a way to fix this?
 
E

Evi

Make sure that the Subforms and the section which contains the subform has
the Can Grow, Can Shrink property set to Yes. Ensure that there are no
controls (eg lines) or labels holding the section open.
If you have page breaks in place, then use the On Format event of section to
make them invisible.

If Me.MySubFormControl.Report.HasData = 0 Then
Me.MyPageBreakControl.Visible = false
Else
Me.MyPageBreakControl.Visible = True
End If

Evi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print report and subreport(no data) without blank page 0
blank pages in report 3
Help with report 1
Hide Sub Report(s) when records are null 6
Print Report If Sub-Report Has Data 2
Blank page between two sub reports 1
Reports, Sub-reports running sum and no data 2
Page break between sub reports of a sub report 1

Top