Are Page Breaks in Reports Arbitrary?

[TheSearcher]

I have a report consisting of a few subreports. In certain instances a subreport will appear on the following page (or several spaces down from the sub above it) for no obvious reason. I changed Keep Together to "No" in the report footer and this resolved one occurrance. Does anyone know how I can control the spaces and page breaks on this report?
Many thanks,
TS

 

[AHeyne]

Sounds to me like the data contained in the report causes this behaviour in these particular cases.

 

[theDBguy]

Try reducing the size of all your subreports to a minimum height and make sure it's set to Can Grow = Yes. Then, stack all your subreports close to each other.

 

[The_Doc_Man]

Every section has that "Keep Together" option. There is also a general term called "orphan" that, for anything in print, means a single line that is part of a larger element but the element breaks after the 1st line (leaving a top orphan) or just before the last line (leaving a bottom orphan). I'm not sure about controlling that other than perhaps writing some complex event code to dynamically force or prevent a break, or trying various statically declared combinations of KeepTogether or ForceNewPage as appropriate.

The "several spaces down" part sounds like you might have blank lines somewhere that you didn't realize you had, or might have blank records in a detail section such that the lines appear empty but actually have spaces.

 

[TheSearcher]

Thanks everyone. I tried all suggestions plus I set the "Can Shrink" property to "Yes" on each subreport. No change.
I didn't test changing the data because I need the report to be consistent regardless of what data I'm using.
When Access formats the report and sends it to Print Preview there must be some property (or something) that tells it when to add spaces or a page break. Does anyone know what this property is?

 

[theDBguy]

Just a guess, but try adjusting the margins?

 

[TheSearcher]

Thanks Pat. All of the queries used for my subreports have 1 blank field at the bottom (see attached). But not all are problematic. I will check the sorting now. Appreciate your help!

 

[TheSearcher]

@theDBguy - Can you please elaborate on your last suggestion? There is a property called Show Page Margins. The choices are Yes or No. Is this what you mean? The report itself is right at the edge of all subreports therin.

 

[theDBguy]

@theDBguy - Can you please elaborate on your last suggestion? There is a property called Show Page Margins. The choices are Yes or No. Is this what you mean? The report itself is right at the edge of all subreports therin.

Sorry, that's not what I was thinking about. I was thinking the report will render as much it can fit in a page based on your margin settings. Based on whether you have Keep Together or not, it might push some data that can still fit onto the next page and produce gaps.

 

[TheSearcher]

I resolved this by resizing all of the subreports within the main report. It seems that some were overlapping slightly. Not sure why this would cause extra space - but problem solved.
Thank you all!!!

 

[theDBguy]

I resolved this by resizing all of the subreports within the main report. It seems that some were overlapping slightly. Not sure why this would cause extra space - but problem solved.
Thank you all!!!

Glad to hear that, but that was basically what I was saying originally. Cheers!

 

[June7]

The blank field showing in query image is just the new record row that shows in an editable table or query. It is not a blank record that will include in report output.