How do I skip pages?

[cybermarcello]

Hi there,

I have a main report containing 10 subreports. Every subreport has another report as it's recordsource. Now, depending on the value 10 different booleans, all or none of the subreports should be visible. I have achieved this by writing the on open event procedure for the main report, but for the invisible subreports blank pages are printed, and these pages should be skipped. Does anyone have an idea how to do this?

Thanks.

 

[dhookom]

If you are using PageBreak controls, then you need to make them visible or invisible.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[cybermarcello]

Thanks for your reaction dhookom, but I already use them. They do what they have got to do, that is start a new page after each subreport. What I tried is making the subreports invisible in the code dependent upon boolean values. However, it keeps printing empty pages after in the place of the invisible subreports...

 

[dhookom]

Ok, so you are using pagebreak controls and you are making subreports visible or invisible.
Are the subreports and sections set to can shrink?
Are you setting the pagebreak controls to visible or invisible (suggested previously)?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[cybermarcello]

Now I get it, the subreports set to invisible is not enough, the pagebreak is outside the subreport and will force a blank page. Thanks DHookom, your tip directed me towards the solution.