Page Footer + Can Grow

In Access 2000 I have a report. I need to put a sub report in the Page footer and set the sub reports "Can Grow" to yes.
However, it does not grow at run time!

How do I get it to grow?
TimTDPAsked:
Who is Participating?
 
harfangCommented:
As I said, this is not possible. If you think about it, there is no way to implement growing page footers, either. Access (or any other page-formatting software) needs to know the size of the footer before it starts printing the page.

If you really need it, I see only this tweak (MDB files only):

 * Open report rptCheckSize, containing only a detail section with the same subreport
 * In Detail_Format, record the size of the subform control to a global variable
 * Open your rptPageFooterStunt report in _design_ view
 * Adjust the size of the footer (and while you are at it of the subform control)
 * Switch to report preview...

I have to say I keep wondering what makes you need a subreport in a footer anyway. Care to explain?

Cheers!
(°v°)
0
 
harfangCommented:
Hello,

The subreport can grow, but not beyond the size of the footer. The page footer cannot grow. There is a trick for growing page headers, but not footers. You will have to set aside enough space for it.
Sorry.

(°v°)
0
 
TimTDPAuthor Commented:
What is the trick?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
harfangCommented:
The trick is to add a dummy group, for example on the expression "=True" at the very top in "Sorting and Grouping". Then select Group Header: Yes, and, on the header itself, choose Repeat Section: Yes. That way, you get a second hand-made page header.

However, this doesn't work for footer.

Cheers!
(°v°)
0
 
TimTDPAuthor Commented:
I have already done this.

It is the page footer I can't get right!
0
 
TimTDPAuthor Commented:
For a generic report for company documents.

I have different company's, each with their own header and footer details. I have reports for each company's header and footer, which are inserted as sub reports in the main report. At run time I change the source of the sub reports to reflect the correct company. I can never guarantee that the height will always be the same for each company, hence the "can grow" requirement.
0
 
harfangCommented:
Ah, ok. We did use that security scheme in one of project I was working on. However, we only inserted a fixed-size form as subform on the reports. (It was a form, so that we could display the same in the "About" box and some other forms...)

If you generate MDE files for your clients, you could run a function that will loop through all reports and adjust the page footers and save. Then generate the customized MDE.

If you distribute MDB files, you could include a tool in some options dialog: refresh reports for changed footer layout, so that they can do that themselves.

From what you describe, run-time adjustments are probably not a good idea...

Good luck!
(°v°)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.