Suppress page break if subreport has no data

T

TES

I have a report with 9 subreports and a page break control after each
subreport. When a subreport does not contain any data, I get a blank page. Is
there a way to suppress the page break control when a subreport has no data?
 
J

John Spencer

In the format event of the main report section containing the sub report.

Me.SomePageBreakControl = Not(Me.SomeSubReport.HasData)
 

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

How to bulk add section breaks after a particular combination of letters/numbers 0
Subreport with no records 8
Two columns followed by single page-width column on same page 0
Error 2467 in report after splitting database 0
Determine if previous "character" is a section break 3
Suppress hard page-break if no data? 4
Move subreport up if report above it is not visible 0
Suppress Blank Subreports 2

Top