Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional page breaks in a long report

Status
Not open for further replies.

Gresford

Programmer
Apr 3, 2002
10
GB
Hi
Is there a simple way of associating a page break with a control, so that if the control (in this case sub-report) shifts to take the place of another 'shrunken' control, the page break moves with it?

I have a series of sub-reports each with a page break directly after it. If the data for a given sub-report is blank, I'm making that sub-report invisible (and making its associated PageBreak invisible), and its Shrink property is set to Yes so that the next sub-report slides up to take its place. Unfortunately, although the remaining sub-reports are sliding up fine, their page breaks seem to retain their original position, and so start cutting the report in weird places.

Any ideas how to get round this?

Matthew
 
Gresford,

Why use page brakes? Make your subreports as thin as possible, put them together and put ForceNewPage property for the footer of subreports to After Section.

ps: It works but debuging this thing may be a nightmare :). Its usefull if these reports dont change often.
 
Just tried this. But the ForceNewPage property in the sub-reports is being ignored - in fact all the Page/Report Header and Footer sections in the sub-reports are ignored - and only their Detail sections are included when the main report prints. Is there some way of affecting this?
Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top