Dynamically re-size page footer to display sub-report

Posted on 2009-04-07
Medium Priority
Last Modified: 2013-11-28
I am trying to embed a sub-report within the page footer of my report.

An issue has presented due to the variable height of this sub-report, I seem unable to
force the page footer section to dynamically resize at runtime.

I note that the 'CanGrow' & 'CanShrink' properties are not available for this section, but
surely there must be some way of making the section fit the sub-report?

I've tried the 'AutoHeight' property to no effect.
Question by:MISLtd
  • 2
LVL 77

Expert Comment

ID: 24087690
I''m afraid what you are asking is not possible in Access.
Page footers are fixed size.

You will have to look at using a group footer or report footer secton for your subreport.

Author Comment

ID: 24089280
I had hoped that this was not the case...

At least I can justify to an extent the wasted time I've spent trying to achieve this goal.

I have actually managed to progmatically alter the page footer section height at runtime ( http://msdn.microsoft.com/en-us/library/aa206046(office.10).aspx ), however determining the sub-reports runtime size seems to be a little more difficult.

Ill battle on for now.
LVL 77

Accepted Solution

peter57r earned 2000 total points
ID: 24089563
If you try to adjust the height at runtime you need to make the change in the pageheadersection format event procedure, otherwise you will find you are always one page behind the code.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24090902

You did not provide any info on the specifics of the report so I will take a few shots.

The Page footer is not made to display Totals or contqain subreports.
What is the reason why you cannot put the subreport in the "Report" footer?

Another option, if practical:
To work around this, try grouping the report and put the subreport in the Group footer.

Then set the: "Force New Page"  Property to:  "After Section".

This will but the subreport at the bottom of each groups last page.

If niether of these will help you, then can you explain what the Main report and the subreport are trying to display, and describe exactly what you want the report to look like.



Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

624 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