Repost on Gap between sub report and report

[Klatuu]

I am reposting this in hopes someone did not see it before and can assist.

I have a report that required the summary data at the top of each page(stupid
user requirement.) The sub report lists a row of data for each manager and a
grand total row at the bottom. The main report has a row for each project
for each manager and it grouped by manager to get a subtotal by manager. The
user can select which kinds of projects to include on the report.

My problem is that when one project type is selected, there are round 10 to
11 Managers. I have the report laid out so that there is about a 1" gap
between the data in the sub report (header) and the main report. If the user
selects another project type and there are only 6 - 8 managers, then the gap
get much larger and report looks goofy.

Every section of both reports that have Grow and Shrink properties have both
set to Yes.

What I need is the detail of the Main report to stay 1" from the bottom of
the Sub report data regardless of how many rows are in the Sub.

I will be eternally grateful and promise whomever can resolve this mass
quantities of your favorite adult beverage.

 

[Marshall Barton]

I am reposting this in hopes someone did not see it before and can assist.

I have a report that required the summary data at the top of each page(stupid
user requirement.) The sub report lists a row of data for each manager and a
grand total row at the bottom. The main report has a row for each project
for each manager and it grouped by manager to get a subtotal by manager. The
user can select which kinds of projects to include on the report.

My problem is that when one project type is selected, there are round 10 to
11 Managers. I have the report laid out so that there is about a 1" gap
between the data in the sub report (header) and the main report. If the user
selects another project type and there are only 6 - 8 managers, then the gap
get much larger and report looks goofy.

Every section of both reports that have Grow and Shrink properties have both
set to Yes.

What I need is the detail of the Main report to stay 1" from the bottom of
the Sub report data regardless of how many rows are in the Sub.

It sounds like you forgot to set the subreport control's
CanShrink property to Yes. (The subreport control is on the
main report.) Either that or you have other controls next
to the subreport control.

 

[Klatuu]

Marshall,

Thanks for the response. I rechecked and the subreport is set to Can Grow
and Can Shrink. Every section of both the report and sub report that have
Grow/Shrink properties are all set to yes.

There are no controls next to the sub report. It spans the width of the
report. The closest object to it is the detail section of the main report.

 

[Marshall Barton]

Don't know what happened here, but my reply to your last
question just poped up on my screen (after 2 weeks???). I
don't have a clue how that could happen and I'm sorry to be
so late in getting back to you. Also sorry that I don't
have much in the way of an answer either.

Just in case you are still working the issue, here's the
(better late than never?) awol reply.


How about in the subreport? Any lines? White space?

You said the subreport appears at the top of each page.
Does this mean it's in the Page Header section? If so, note
that the page header section can not shrink.

 

[Klatuu]

Ahhh Yes, that must be it. Sometimes you have to cut down all the trees so
you can see where the forest was. Now I have to figure a way around this. I
guess when they designed the report writer, they never imagined (nor whould I
have) that some dummy would want what should logically be a report footer
printed at the top of every page. (lets all hear it for bean counter brain
power).

So, now I have to find a way around this. Wonder if in the On Format event
of the page header, I could determine the number of rows in the page header
and changed its height property? Would the Detail grow to fit it, or will it
start where it starts and I have to adjust for that, too?

Something must be happening on the system here, I got a reply message to a
post I had not even read this morning.

Thanks againg, Marsh.

Don't know what happened here, but my reply to your last
question just poped up on my screen (after 2 weeks???). I
don't have a clue how that could happen and I'm sorry to be
so late in getting back to you. Also sorry that I don't
have much in the way of an answer either.

Just in case you are still working the issue, here's the
(better late than never?) awol reply.


How about in the subreport? Any lines? White space?

You said the subreport appears at the top of each page.
Does this mean it's in the Page Header section? If so, note
that the page header section can not shrink.
--
Marsh
MVP [MS Access]

Thanks for the response. I rechecked and the subreport is set to Can Grow
and Can Shrink. Every section of both the report and sub report that have
Grow/Shrink properties are all set to yes.

There are no controls next to the sub report. It spans the width of the
report. The closest object to it is the detail section of the main report.