?
Solved

Page Footer + Can Grow

Posted on 2006-04-09
7
Medium Priority
?
448 Views
Last Modified: 2006-11-18
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?
0
Comment
Question by:TimTDP
  • 4
  • 3
7 Comments
 
LVL 58

Expert Comment

by:harfang
ID: 16411949
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
 

Author Comment

by:TimTDP
ID: 16412077
What is the trick?
0
 
LVL 58

Expert Comment

by:harfang
ID: 16414668
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:TimTDP
ID: 16414733
I have already done this.

It is the page footer I can't get right!
0
 
LVL 58

Accepted Solution

by:
harfang earned 100 total points
ID: 16414950
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
 

Author Comment

by:TimTDP
ID: 16414999
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
 
LVL 58

Expert Comment

by:harfang
ID: 16415076
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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question