Subs Report Overflowing into Each Other

[marseneault]

Hello, I have several design issues with a report that I am creating. This report has the following:
Project Name and Data at the top
3 subreports in the main body, 2 that are above and below each other
Project Financials and Invoices at the bottom

The Problem that I am running into is that one of the reports is overflowing into the others at the bottom of the page.

I have set the option "Can Grow" and placed Them apart in Design Mode, But in Print Preview, they overlap each other randomly. Any Thoughts

 

[isladogs]

Can you please show us screenshots of the reports in both print preview and design view.
As you have less than 10 posts, zip them into one file

 

[marseneault]

Sure, No Problem. Please see the attached files

 

[isladogs]

Well its not random!
You have too many records to fit the space and have set Can Grow = Yes ...so it does!
That doesn't instruct the others to move down.

So you have a few choices:
1. Set Can Grow to No ... but you won't see all the records
2. Move the subreports down further or onto the next page
...but that will leave a gap when you have fewer records
3. Programmatically set the position of the lower subreport(s) depending on the height
of the subreports above

The third suggestion is the best but it will require code.
You should be able to find something suitable with a forum or Google search

The attached examples both show how to do something similar in forms.
You may be able to work out what to do from one or both of these