Columns and subreports

[Alex]

I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto
the same page as the subreport, it always goes onto another page even
when there is obviously room for it on the first page.
I have the main report detail section set to can grow Yes if I set
this to No the subreport seems to then only print a single column.

Alex

[Salad]

Alex wrote:

I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto
the same page as the subreport, it always goes onto another page even
when there is obviously room for it on the first page.
I have the main report detail section set to can grow Yes if I set
this to No the subreport seems to then only print a single column.

Alex

On a situation like this, I cheat. I add a column to the reports
recordsource. Open up the query and enter
Master : "M"

Now make Master the first column to group on (Edit/Sorting&Grouping from
the menu). Add a footer to Master. Move the data from the ReportFooter
to the Master footer.

Since the Master sort column contains only 1 value, the break is always
at the end.

[Alex]

Salad <oi*@vinegar.com> wrote in message news:<EQ*****************@newsread3.news.pas.earth link.net>...

Alex wrote:

I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto
the same page as the subreport, it always goes onto another page even
when there is obviously room for it on the first page.
I have the main report detail section set to can grow Yes if I set
this to No the subreport seems to then only print a single column.

Alex

On a situation like this, I cheat. I add a column to the reports
recordsource. Open up the query and enter
Master : "M"

Now make Master the first column to group on (Edit/Sorting&Grouping from
the menu). Add a footer to Master. Move the data from the ReportFooter
to the Master footer.

Since the Master sort column contains only 1 value, the break is always
at the end.

Thanks for that. The footer is now at the end of the page but it is in
the last column. I want it to be the full page width. The report has a
header that spans the full page and a footer that must also span the
page. The detail section is in four columns.
Alex

[Salad]

Alex wrote:

Salad <oi*@vinegar.com> wrote in message news:<EQ*****************@newsread3.news.pas.earth link.net>...

Alex wrote:

I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto
the same page as the subreport, it always goes onto another page even
when there is obviously room for it on the first page.
I have the main report detail section set to can grow Yes if I set
this to No the subreport seems to then only print a single column.

Alex

On a situation like this, I cheat. I add a column to the reports
recordsource. Open up the query and enter
Master : "M"

Now make Master the first column to group on (Edit/Sorting&Grouping from
the menu). Add a footer to Master. Move the data from the ReportFooter
to the Master footer.

Since the Master sort column contains only 1 value, the break is always
at the end.

Thanks for that. The footer is now at the end of the page but it is in
the last column. I want it to be the full page width. The report has a
header that spans the full page and a footer that must also span the
page. The detail section is in four columns.
Alex

Hmmm...I guess this is where you need to fiddle and fart with it.
Something you could test would be to set a global variable for the
report to false when the report opens. Then set it to true with you get
to the Master footer. Move your fields into the page footer. Only
print the fields when true.

See MoveLayout, PrintSection in help. You'd either set this on the
OnFormat or OnPrint event.

[Rebecca]

Alex wrote:

I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto
the same page as the subreport, it always goes onto another page even
when there is obviously room for it on the first page.
I have the main report detail section set to can grow Yes if I set
this to No the subreport seems to then only print a single column.

Alex

Alex,

I have a similar report, except that the subreport is in an inner
footer, and there is text in the report footer that I need on the same
page. I set the subreport control to "can grow" = No, to force the
columns, since with it set to Yes, I always got just one column and it
went on for pages until it was done. And as I look now, the sections
themselves are all set to "can grow" = Yes, but since that subreport
isn't going to grow, it won't overflow the page. I did have to play a
bit with the size I give the subreport to allow enough space for the
data that appears there, but to also keep the footer on the page.

Rebecca