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

SubReport Footer not Printing

P: n/a
I am STUCK!

I have an Access2000 report; main report and subreport. The sub report
is 2 columns, with a footer controlled by a value in a field.

The Report Footer should have SUM of values in the report.

My problem is that the Report footer of the Subreport doesn't print!

The main report prints fine; the sub-report prints fine, except there
is NO footer.

The main report's page footer prints at the bottom of the report.

Help, Please!!
Thanks,
Sara

Nov 13 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
sara wrote:
I am STUCK!


Ask Steve.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #2

P: n/a
sara wrote:
I am STUCK!

I have an Access2000 report; main report and subreport. The sub
report is 2 columns, with a footer controlled by a value in a field.

The Report Footer should have SUM of values in the report.

My problem is that the Report footer of the Subreport doesn't print!

The main report prints fine; the sub-report prints fine, except there
is NO footer.

The main report's page footer prints at the bottom of the report.

Help, Please!!
Thanks,
Sara


Are you sure it's a Report Footer and not a Page Footer? Page Header/Footers
don't work in subreports, but Report Header/Footers should.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #3

P: n/a
I am positive it is a Report Footer - Page is empty.

It is visible, and I've tried can grow and can shrink with both yes and
no.
Now what?

Sara

Rick Brandt wrote:
sara wrote:
I am STUCK!

I have an Access2000 report; main report and subreport. The sub
report is 2 columns, with a footer controlled by a value in a field.
The Report Footer should have SUM of values in the report.

My problem is that the Report footer of the Subreport doesn't print!
The main report prints fine; the sub-report prints fine, except there is NO footer.

The main report's page footer prints at the bottom of the report.

Help, Please!!
Thanks,
Sara
Are you sure it's a Report Footer and not a Page Footer? Page

Header/Footers don't work in subreports, but Report Header/Footers should.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


Nov 13 '05 #4

P: n/a
sara wrote:
I am positive it is a Report Footer - Page is empty.

It is visible, and I've tried can grow and can shrink with both yes
and no.
Now what?


A subreport with columns has to be set up to snake the columns "Across, Then
Down" rather than "Down, Then Across". Is that how you have it?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #5

P: n/a
Who is Steve? HOW do I ask him?

Nov 13 '05 #6

P: n/a
I finally got to try this - going Across, then Down, actually made it
worse! I didn't get any of my totals footers (I have one, but code
determines what's in it). The report gave me only the first 13 lines,
then no total for those lines, and none of the other items (2 other
groups have detail lines). All of these show up when I do Down, Then
Across. I just don't get the total of all of the lines, which is in
the footer.

Thanks

Nov 13 '05 #7

P: n/a
sara wrote:
I finally got to try this - going Across, then Down, actually made it
worse! I didn't get any of my totals footers (I have one, but code
determines what's in it). The report gave me only the first 13 lines,
then no total for those lines, and none of the other items (2 other
groups have detail lines). All of these show up when I do Down, Then
Across. I just don't get the total of all of the lines, which is in
the footer.

Thanks


"Down and Across" tells the report to start a new column when the bottom margin
of the page is reached. A subreport has no way of knowing when the bottom of
the page (in the parent) is reached so you end up with a single column for all
records.

The exception to this is if you have the subreport control set to CanGrow = No.
Then the bottom of the subreport control will act as the bottom of the page. Of
course if you have CanGrow set to know that might explain why you don't see your
footer. It is likely further down than the size of the control will display.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #8

P: n/a
Still not working. I even tried "force new row or column" - works when
you run the sub report by itself, but still no Report Footer from the
subreport on the main report. The main report's page footer is
showing; it doesn't have a report footer.

Any other ideas?
This is killing me!
Thanks -
sara

Nov 13 '05 #9

P: n/a
sara wrote:
Still not working. I even tried "force new row or column" - works when
you run the sub report by itself, but still no Report Footer from the
subreport on the main report. The main report's page footer is
showing; it doesn't have a report footer.

Any other ideas?
This is killing me!
Thanks -
sara


You do have CanGrow enabled on the subreport control right?

Simplify and conquer. Remove the multi-column setting from the sub report and
change the section background color of the Report Footer. Then try it. If the
report footer is still not there you can at least see if any of the different
color appears. That will tell you if any part of the section is coming through
versus just not seeing any of the controls.

Try temporarily modifying the RecordSource of the subreport so that it only
returns one or two records and see if that makes any difference.

Heck, if you have to just substitute an unbound report as the SourceObject of
the subreport control temporarily with each section in a different color and see
what you get. You'd have to temporarily remove the MasterLink/ChildLink
settings for that test.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #10

P: n/a
Well, I got the report to work, thanks to your suggestions. I still
don't understand why, but I took out the columns (and formatted the
report so it all fits on one page), and it's fine! It also worked with
2 columns and CanGrow set to yes, but it still printed in one column
only.

I'll play with it some more when I'm not under pressure. I like the
idea of "divide and conquer" and using color to debug.

Many many thanks. I am the only "programmer" in this company, so
without the web, I'd be sunk!

Have a nice holiday weekend.
sara

Nov 13 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.