Subreports keep shifting position

[Chase998]

I have a report that contains upwards of five subreports of required information in two columns (two on the left, three on the right). However, when I try to put all of them into a report using landscape orientation on the page so that I only get one page, I find that some of the subreports on the right side shift to the position and align to the bottom of the adjacent report to the left. It looks like text wrapping issue you might see in Word.

I have tried creating multiple columns on the report, set the "grows" to both yes and no, and still it shifts the subreports around.

Is there something I'm missing to stop this? There's plenty of room on the page for all the subreports to fit, but I can't get them to stay put!

Thanks!

CHASE

 

[dhookom]

As the controls on the left side grow, they will push all controls below its bottom downward.

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

 

[Chase998]

Duane,

Thanks for the reply! Any way around this problem, or am I destined to be held hostage by Access?

CHASE

 

[dhookom]

You could try embed the left side subs into their own subreport and the same with the right. Then add the Left sub and right sub to the main report.

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

 

[Chase998]

Gave it a try, but I get a nesting error because Access has a fit with 3-level subreports.

Each subreport at the highest level contains two individual subreports. So, in essence, I am putting 10 separate reports in one main report, each subreport containing two subreports.

Am I just pushing Access's limit to display certain data?

CHASE

 

[dhookom]

You might be pushing the limit. Did you try all possible combinations of overlapping slightly from left to right? Did you try make the report half as wide and then placing the subreports vertically in a line?

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

 

[Chase998]

I've tried every placement trick I know, including overlapping, to stop it from pushing the subreports around. That's why I thought there might be a wrapping function in Access I was missing.

I had a hunch that there was no exact science to keep this from happening, but I thought I'd throw it out to those in the know to make sure!

If there is no solution, then I will accept that (with just a LITTLE grumbling about Microsoft products<g>).

Thanks!

CHASE