SubReport Footer not Printing

[sara]

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

[Tim Marshall]

Re: SubReport Footer not Printing

sara wrote:
[color=blue]
> I am STUCK![/color]

Ask Steve.

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

[Rick Brandt]

Re: SubReport Footer not Printing

sara wrote:[color=blue]
> 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[/color]

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

[sara]

Re: SubReport Footer not Printing

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:[color=blue]
> sara wrote:[color=green]
> > 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[/color][/color]
field.[color=blue][color=green]
> >
> > The Report Footer should have SUM of values in the report.
> >
> > My problem is that the Report footer of the Subreport doesn't[/color][/color]
print![color=blue][color=green]
> >
> > The main report prints fine; the sub-report prints fine, except[/color][/color]
there[color=blue][color=green]
> > is NO footer.
> >
> > The main report's page footer prints at the bottom of the report.
> >
> > Help, Please!!
> > Thanks,
> > Sara[/color]
>
> Are you sure it's a Report Footer and not a Page Footer? Page[/color]
Header/Footers[color=blue]
> 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[/color]

[Rick Brandt]

Re: SubReport Footer not Printing

sara wrote:[color=blue]
> 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?[/color]

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

[sara]

Re: SubReport Footer not Printing

Who is Steve? HOW do I ask him?

[sara]

Re: SubReport Footer not Printing

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

[Rick Brandt]

Re: SubReport Footer not Printing

sara wrote:[color=blue]
> 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[/color]

"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

[sara]

Re: SubReport Footer not Printing

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

[Rick Brandt]

Re: SubReport Footer not Printing

sara wrote:[color=blue]
> 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[/color]

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

[sara]

Re: SubReport Footer not Printing

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