Reports in a report

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

Guest

I have several small reports that show up in a larger report. The smaller
reports are organized into three columns. I have each report placed two grid
spaces below the previous. The first column of reports looks fine. In the
second, some of the reports show up an inch or more below the previous, even
though they are only a couple spaces from each other. What can I do to fix
this?
 
Ignore the reply "you cant do this with microsoft access 2003".

Your main report will expand/stretch vertically across your section. Any
controls to the left or right may be pushed downward by a subreport or
control to the far left or right of the controls.
 
Duane,
The first column of subreports causes the bottom to expand as you described.
But the problem is that the subreports in the second column change position
relative to each other from the Design view. In Design view, I place each of
the second column's subreports one unit below the previous, but when I change
view to the print view, the reports space out from each other much further.
As much as an inch of blank space is placed between some subreports in this
second column.
 
That was my first idea. I left the borders on all the reports when I came
across this. The border only encloses the data in the subreports. The blank
space is not enclosed.
 
That was my first idea. I left the borders on all the reports when I came
across this. The border only encloses the data in the subreports. The blank
space is not enclosed.
 
How is your report different from my sample picture? You suggested a
subreport/control is further down a page then expected. Is there any Can
Shrink or Can Grow above it that might be affecting your position?
 
It looks exactly like what your picture depicts. Except, A and B are
vertically aligned rather than horizontally (ditto with C and D). I have both
Can Shrink and Can Grow set to yes on all subreports.
 
Are you suggesting all four subreports are placed vertically? Is the bottom
of the first subreport higher than the top of any other subreport? Is the
bottom of the second subreport higher than the tops of the 3rd and 4th
subreports?
 
If you swap the positions of B and C in your picture. You have what I have. I
don't know that it matters which is B or C, but I created my first column
completely first, then I created the second column.

Let me give you a more precise idea of my report. I have subreports A-F in
the first column and G-K are in the second column presently (more will be
added later). All subreports have the same width, but different heights. A-F
all line up and are spaced perfectly apart. G's top is in line with A's top,
and H is spaced perfectly under G. A is longer than both G and H combined, so
it extends below H. I is where the problems begin. It is spaced about an inch
below H, and is not in line with the top or bottom of any report in the first
column. This odd positioning repeats for J and K.

Could I easily fix this by creating a seperate report (with subreports) for
each column then combine the columns into a final master report?
 
If you swap the positions of B and C in your picture. You have what I have. I
don't know that it matters which is B or C, but I created my first column
completely first, then I created the second column.

Let me give you a more precise idea of my report. I have subreports A-F in
the first column and G-K are in the second column presently (more will be
added later). All subreports have the same width, but different heights. A-F
all line up and are spaced perfectly apart. G's top is in line with A's top,
and H is spaced perfectly under G. A is longer than both G and H combined, so
it extends below H. I is where the problems begin. It is spaced about an inch
below H, and is not in line with the top or bottom of any report in the first
column. This odd positioning repeats for J and K.

Could I easily fix this by creating a seperate report (with subreports) for
each column then combine the columns into a final master report?
 
What difference does it make what the labels of the controls are? The names
could be Red, Green, Purple, and Yellow. There is an underlying rule here
about controls that Can Grow and how this might affect controls below even
if they are to the right or the left of the Can Grow control.
 
With your setup, almost any growing in either column will affect lower
subreports. If you don't want this, create two new subreports. Place A-F in
one subreport and G-K in the other. Then place these two subreports
side-by-side in a main report.
 
Back
Top