By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 748 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

Columns and subreports

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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.
Nov 13 '05 #4

P: n/a
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

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.