Concatenation subreports in report - formatting question

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

Guest

I've followed instructions in the Microsoft Knowledge Base to create
subreports with concatenated fields that then plop the results into my main
report. It works beautifully but with one small problem. No matter where I
place the subreports - which are set to 0" high and 2" wide, there is quite a
large gap of white space. Since this report needs to appear seamless, I need
to get rid of the white space (the gap). Any idea what is causing this? I've
placed the subreports at the beginning, end, added different headers and
footers to try them in - but I always get that gap. Please help if you can.
(Using Windows XP, Access 2000).
Thanks a lot.
 
1. In report design view, is there white space above or below the subreport
in the section where you placed it? If so, close the space up.

2. Right-click the edge of the subreport control, and choose Properties.
On the Format tab of the Properties sheet, set Can Grow and Can Shrink to
Yes. The subreport can now shrink and grow as needed.

3. If that doesn't solve the problem, check that the Can Shrink property of
the (Detail?) Section is also set to Yes.
 
I'm not sure I'm following this.

There are 3 subreports in the main report's Report Footer section.
They are 0" high.
Their CanGrow is set to yes.
Presumably they are slightly below each other, so they don't actually
overlap, but there's no wasted space between them. And there are no other
controls that overlap them vertically (i.e. nothing else is partially beside
them.)

That should work. For testing, you might want to add a line immediately
above the first one and below the last, and ensure that the extra space is
actually in this section.
 
Back
Top