Subreport 'pushes down' data next to it

[Fred]

Hi all.

I have a landscape report that is setup as single-column (Page Setup).
I have layed out the data in the report in two colums.

In the left 'column' I have a subreport that can be resized (CanGrow=True).
The problem is that whatever control/data starts below that subreport on the
right side of the report, is pushed down to the point where the subreport
ends on the left side.

Is there an easy way to solve this problem ? I have tried to fiddle around
with column setup, but I cnn't work it out. I have also searched the web to
find faq's on colums and layout, but no real answers there either. So anyone
? Please ?

Below is an 'example' of what happens

________________________________________________
REPORT AND PAGEHEADER
________________________________________________

DETAIL SECTION
Data 1 Data A
Data 2 Data B
Data 3 Data C
Data 4 Data D
Data E
Data F
SUBREPORT START Data G
SubreportData <<<<<< Data H-J should start here
SubreportData
SubreportData
SubreportData
SubreportData
SubreportData
SubreportData
SUBREPORT END
Data H
Data I
Data J
________________________________________________
REPORT AND PAGEFOOTER
________________________________________________

 

[Marshall Barton]

I have a landscape report that is setup as single-column (Page Setup).
I have layed out the data in the report in two colums.

In the left 'column' I have a subreport that can be resized (CanGrow=True).
The problem is that whatever control/data starts below that subreport on the
right side of the report, is pushed down to the point where the subreport
ends on the left side.

Is there an easy way to solve this problem ? I have tried to fiddle around
with column setup, but I cnn't work it out. I have also searched the web to
find faq's on colums and layout, but no real answers there either. So anyone
? Please ?

Below is an 'example' of what happens

________________________________________________
REPORT AND PAGEHEADER
________________________________________________

DETAIL SECTION
Data 1 Data A
Data 2 Data B
Data 3 Data C
Data 4 Data D
Data E
Data F
SUBREPORT START Data G
SubreportData <<<<<< Data H-J should start here
SubreportData
SubreportData
SubreportData
SubreportData
SubreportData
SubreportData
SUBREPORT END
Data H
Data I
Data J

That looks like it should be a two column report, but you
probably have a reason for doing it the way you are.

Anyway, you can prevent the subreport from pushing the
controls on the right down the page by making the subreport
control (on the main report) taller so that its bottom is
below the top of the dataJ text box. You will probably want
to set the subreport's CanShrink property to Yes as well.

 

[Fred]

Marshall,

thanks for the info. That helps out a bit, but the problem is that I loose
precious space doing this.

I am trying the 2-colum approach - although It's not very attractive to look
at - and I encounter a problem with keeping objects together in the same
column. I have sections of data (all in the Details section) which usually
have a header text and then a table with a few rows of data. When data is
'pushed' to the second column the header and data rows are often not kept
together.

I have tried grouping the sections (selecting and then > Format > Group),
but that does not seem to work.

There must be an easy way of doing this...

 

[Marshall Barton]

thanks for the info. That helps out a bit, but the problem is that I loose
precious space doing this.

What space are you losing? I didn't see anything in your
example that implied any need space would be lost??

I am trying the 2-colum approach - although It's not very attractive to look
at - and I encounter a problem with keeping objects together in the same
column. I have sections of data (all in the Details section) which usually
have a header text and then a table with a few rows of data. When data is
'pushed' to the second column the header and data rows are often not kept
together.

That was a faint hope ;-)

I have tried grouping the sections (selecting and then > Format > Group),
but that does not seem to work.

Grouping usually means setting up a group for detail records
with a common value in a field (using Sorting and Grouping -
View menu). I don't think what you're looking at will mean
anything to this situation.

There must be an easy way of doing this...

This is usually not too difficult, but it seems that you
have an inordinate amount of data in each detail record.
Maybe that's the source of the complications. If you'll
post a description of the tables and their fields, maybe I
could spot something.
--
Marsh
MVP [MS Access]