Layout trouble for multi-subreport report (Dashboard style)

[JABCCS via AccessMonster.com]

I have a main report with 8 subreports. Each subreport is set to Can Grow.
None of the subreports have any relationship to the others. The entire
report fits on one page. I've laid out the main report with three of the
subreports on the left half of the page (one on top of the other) and 5 of
the subreports on the right half (one on top of the other). I've set the
size of each subreport at .1 inch so the spacing will be consistent, whether
there is data to print or not.

What I'm finding is that the left side subreports and the right side
subreports do not act independently of each other as far as vertical start
position is concerned. For example, if the first subreport on the left side
is 4 inches long and the first two subreports on the right side are 2 inches
long, the second subreport on the right side starts just after 4 inches down,
rather than just after 2 inches down. This jockeying for start position
plays out top to botoom of the report. This causes large gaps between
subreports on the right side of the page.

What I want to have happen is that all the subreports on each side of the
main report print one below the other, independently of what's happening on
the other side of the main report. Any thoughts about what's happening here
and how to work around it?

Thanks for looking!

John

 

[Marshall Barton]

I have a main report with 8 subreports. Each subreport is set to Can Grow.
None of the subreports have any relationship to the others. The entire
report fits on one page. I've laid out the main report with three of the
subreports on the left half of the page (one on top of the other) and 5 of
the subreports on the right half (one on top of the other). I've set the
size of each subreport at .1 inch so the spacing will be consistent, whether
there is data to print or not.

What I'm finding is that the left side subreports and the right side
subreports do not act independently of each other as far as vertical start
position is concerned. For example, if the first subreport on the left side
is 4 inches long and the first two subreports on the right side are 2 inches
long, the second subreport on the right side starts just after 4 inches down,
rather than just after 2 inches down. This jockeying for start position
plays out top to botoom of the report. This causes large gaps between
subreports on the right side of the page.

What I want to have happen is that all the subreports on each side of the
main report print one below the other, independently of what's happening on
the other side of the main report. Any thoughts about what's happening here
and how to work around it?

A CanGrow control will push everything on the page that has
it's Top below the bottom of the growing control, so what
you are seeing is the expected behavior.

Workarounds would depend on what else you have in the main
report. Try using Page Setup (File menu) to set it to two
columns. Then put the first 3 subreports and the other 5 in
different sections. Use the second section's NewRow or
Column property.

If the main report would be messed up by two columns, then
try using an intermediate unbound (sub)report with two
columns to get the desired effect.

 

[JABCCS via AccessMonster.com]

Thanks Marshall. You've confirmed that the behavior I experienced is by
design, so that helps. I haven't worked with multiple columns before so will
experiment with that first. I don't have anything else in the main report
except for these subreports so that might work well. Otherwise, creating two
new "dummy" subreports that contain the subreports for each column sounds
like it would do the trick. I appreciate your help!

I have a main report with 8 subreports. Each subreport is set to Can Grow.
None of the subreports have any relationship to the others. The entire

[quoted text clipped - 17 lines]

the other side of the main report. Any thoughts about what's happening here
and how to work around it?

A CanGrow control will push everything on the page that has
it's Top below the bottom of the growing control, so what
you are seeing is the expected behavior.

Workarounds would depend on what else you have in the main
report. Try using Page Setup (File menu) to set it to two
columns. Then put the first 3 subreports and the other 5 in
different sections. Use the second section's NewRow or
Column property.

If the main report would be messed up by two columns, then
try using an intermediate unbound (sub)report with two
columns to get the desired effect.

 

[Chuck]

I have a main report with 8 subreports. Each subreport is set to Can Grow.
None of the subreports have any relationship to the others. The entire
report fits on one page. I've laid out the main report with three of the
subreports on the left half of the page (one on top of the other) and 5 of
the subreports on the right half (one on top of the other). I've set the
size of each subreport at .1 inch so the spacing will be consistent, whether
there is data to print or not.

What I'm finding is that the left side subreports and the right side
subreports do not act independently of each other as far as vertical start
position is concerned. For example, if the first subreport on the left side
is 4 inches long and the first two subreports on the right side are 2 inches
long, the second subreport on the right side starts just after 4 inches down,
rather than just after 2 inches down. This jockeying for start position
plays out top to botoom of the report. This causes large gaps between
subreports on the right side of the page.

What I want to have happen is that all the subreports on each side of the
main report print one below the other, independently of what's happening on
the other side of the main report. Any thoughts about what's happening here
and how to work around it?

Thanks for looking!

John

Make a new subreport that contains the 2 left side subreports and another new
subreport that contains the 3 right side subreports. Delete the current 8
subreports from your report and replace those 8 subreports with the two new
subreports.

Chuck

 

[JABCCS via AccessMonster.com]

Thanks Chuck. This ended up being the correct solution and it worked
beautifully!

I have a main report with 8 subreports. Each subreport is set to Can Grow.
None of the subreports have any relationship to the others. The entire

[quoted text clipped - 21 lines]

John

Make a new subreport that contains the 2 left side subreports and another new
subreport that contains the 3 right side subreports. Delete the current 8
subreports from your report and replace those 8 subreports with the two new
subreports.

Chuck