Multiple page report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My report design fits into the 22" design view. However my 2nd to last
subreport is is populated by many records that are overlapping into an area
where there are calculated fields at the end of the report. I need a larger
area for the second to last subreport but can't expand the report any more.
How do I accomodate that?
 
JoeA2006 said:
My report design fits into the 22" design view. However my 2nd to last
subreport is is populated by many records that are overlapping into an area
where there are calculated fields at the end of the report. I need a larger
area for the second to last subreport but can't expand the report any more.
Click to expand...


If you don't have some other things going on, make the
subreport as short as you can tolerate (1/2 inch??). Then
drag the controls below it up to just below the bottom of
the subreport control. Make double sure that none of the
controls overlap amd the the subreport control's and the
section it is in both have their CanGrow property set to
Yes. Once all that is done, you should be able to drag the
bottom of the section up to the bottom of the lowest
control.
 
So Basically, there is no correlation between the subreport height in the
designer and how it behaves at runtime. As long as the CanGrow property is
set to yes a subreport will grow to the size it needs and the position of
other control adjust accordingly. Is that correct?
 
With a few exceptions, yes, that is correct. If you are
reaally running short of design space, you can even make
your text boxes very short (e.g. 1/10 inch) and let them
grow to whatever is needed to display their runtime value.

There are a couple of situations where you might not want a
control to grow, but those are rather unusual. The one that
comes to mind is a multicolumn subreport that must have down
then across snaking (a CanGrow multicolumn subreport must
use across then down snaking).

And don't forget about the CanShrink property. This is
extraordinarily useful when you want to reclaim the vertical
space that might be blank when a field has a Null value.
 
Back
Top