Subreport ruins my formatting

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

Guest

I have a report which contains two subreports. The subreports change their
hight according to how much data they need to display.

The two subreports are situated on the right-hand side of my report, one
above the other. But as they change size they change the line spacing between
the fields on the left-hand side of the report.

Is there any way to prevent this?

Cheers,
Seth
 
You probably need to change those fields to Can Grow = No. But that does
mean they may not show all the data if it's longer then the space you allow.
 
Seth,

This type of thing can sometimes be difficult. Depending on the details
of your report's design, you may be able to make a separate subreport
for the controls in the left-hand side of the existing report.
Otherwise, you have to make sure in your report design that the bottom
edge of any control which may expand vertically (such as your existing
subreport) is not higher than the top edge of another control which you
don't want "pushed down". To achieve this, sometimes it helps to make
the controls whose relativity to each other you want to preserve (for
example your left-hand controls) very short, with their Can Grow
property set to Yes, so that their physical placement on the report
design is within the vertical space occupied by the subreport. Or, size
the subreport control to make it bigger, so its botom edge in report
design is below the top edge of the lowest of the affected left-hand
controls. Hope that makes sense!
 
Back
Top