Aug 26 2011, 09:12 PM
I've got a report and for the life of me can't seem to figure out how to get the first level sub report to start it's next record on the same page as the first. Please see the attached image - not quite sure how to explain.Click to view attachment
I want the second Detail record to start directly under the first one (on page 1 rather than page 2), and have the Prospective Dates list be carried over to the next page.
I've tried setting all the pertinent properties I can find on each of the subforms (grouping and sorting as well) to no avail.
Many thanks for any insight,
Aug 26 2011, 10:25 PM
Are you forcing a page break in one of the groups?
Do you have the keep together property set for the groups?
It looks like the problem is that the second set won't fit on the first page and so that is why it is starting a new page. Try the report with fewer line items to see if the paging works better. That may help identify what is causing the problem.
Aug 26 2011, 10:52 PM
As far as I can tell I'm not forcing any page breaks, and as far as I can tell I've got all the "Keep Togethers" set to True. I don't do a ton of reporting, so I'm relatively infamiliar with the intricacies of them, so I may be missing something.
If I reduce the number of lines in the last nested subreport both of the detail subreports show on the same page. If I increase one detail item's prospective qty breakdown so it's far to long for a single page, the prospective qty's are listed carring over to the next page, if it's any help. Snapshots attached.
I'm not doing anything special with sorting and grouping... each sub is on the many side of it's parent with the master/childs linked as standard. I had nothing in for grouping and sorting until I was playing around with it attempting to get this right, at which point I specified the ID field and all the "Keep Together" settings found in that dialog, but changing any settings (through the Sorting & Grouping dialog or the Properties box) made no apparent effect on the layout.
Aug 26 2011, 10:59 PM
If it might mean anything, the last nested subreport (prospective dates) is filled via temp table whose data is input on said subform's Open event, but I can't think of any way that might have an effect on it.
Aug 26 2011, 11:34 PM
I guess I wasn't clear. It is the keep together property that is causing the problem You are telling Access to keep the group together and since the entire group won't print on page 1, the entire group is printed on page 2. Change the keep together property to be No.
Aug 26 2011, 11:39 PM
Now I know how Keep Together works - the opposite what I assumed.
Thanks for the help, all set now.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here