Sub Reports not Lining Up

  • Thread starter Thread starter Stacey Crowhurst
  • Start date Start date
S

Stacey Crowhurst

Hi. I have a report "rptKnownsProjectedUnknonws". In it are three sub
reports and two sub forms
1. rsubKnowns
2. rsubProjected
3. rsubUnknowns
4. fsubProjectedCostSummary
5. fsubRevisedAvailableContingency

They are arranged like so...
1 4
5

2 3

Numbers 4 and 5 are just calculations so they don't take up much vertical
space compared to numbers 1, 2 and 3. In my report, I noticed that number 5
will only start when number 1 is finished. Is there anyway to have them side
by side? Numbers 1 and 4 and then 2 and 3 start side by side without a
problem. I'm not sure what property I need to adjust.

Let me know if this makes sense. Thanks for helping!
Stacey
 
Hi. I have a report "rptKnownsProjectedUnknonws". In it are three sub
reports and two sub forms
1. rsubKnowns
2. rsubProjected
3. rsubUnknowns
4. fsubProjectedCostSummary
5. fsubRevisedAvailableContingency

They are arranged like so...
1 4
5

2 3

Numbers 4 and 5 are just calculations so they don't take up much vertical
space compared to numbers 1, 2 and 3. In my report, I noticed that number 5
will only start when number 1 is finished. Is there anyway to have them side
by side? Numbers 1 and 4 and then 2 and 3 start side by side without a
problem. I'm not sure what property I need to adjust.

Let me know if this makes sense. Thanks for helping!
Stacey
Click to expand...

Hi Stacey,

Access reports don't support Can Shrink and move up lower subreports
when they are placed side-by-side. So in your example, if you are
expecting 4 to shrink and move 5 up underneath it, that won't work.
I'm assuming for 1 you have Can Grow set to Yes.

However, if 4 and 5 are fixed heights, then if you make them the
correct size on the report you should be able to get 5 to appear next
to 1 as long as your design of 1 extends down past the top of 5. That
sounds complicated as I read it back, but hopefully it's clear enough.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Stacey said:
Hi. I have a report "rptKnownsProjectedUnknonws". In it are three sub
reports and two sub forms
1. rsubKnowns
2. rsubProjected
3. rsubUnknowns
4. fsubProjectedCostSummary
5. fsubRevisedAvailableContingency

They are arranged like so...
1 4
5

2 3

Numbers 4 and 5 are just calculations so they don't take up much vertical
space compared to numbers 1, 2 and 3. In my report, I noticed that number 5
will only start when number 1 is finished. Is there anyway to have them side
by side? Numbers 1 and 4 and then 2 and 3 start side by side without a
problem. I'm not sure what property I need to adjust.
Click to expand...


If I followed that, I think you can get close to what you
want by making subreport1's control tall enough so that 4
and 5 are not below the bottom of 1.

Try to make 4 and 5 the close to the right height, because
if 4 grows or shrinks, 5 will not move down or up.

Put 2 and 3 below the bottom of 1 and make sure their Top
properties are the same.
 
Back
Top