If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report footers
I have a problem with my report footer, when the report consist of more than one page I dont get the footer to stay on the bottom of the page.
I have tried to use the page footer but then I get the text on every page not only the last one which I what. Anybody with a good tip on how to solve my problem?? |
#2
|
|||
|
|||
Report footers
On Thu, 20 May 2004 16:01:05 -0700, gorgas wrote:
I have a problem with my report footer, when the report consist of more than one page I dont get the footer to stay on the bottom of the page. I have tried to use the page footer but then I get the text on every page not only the last one which I what. Anybody with a good tip on how to solve my problem?? The Report Footer prints after the last Detail line, not necessarily at the bottom of the page. If you have data in the Report Footer that you wish to only show at the bottom of the last page, here is one method to do so. Make your report as you normally would with the Page Footer and Report Footer. Make sure there is a control set to = [Page] & " of " & [Pages] in the Page Footer. You can make it not visible if you don't want to show it. Then for each control you wish to display on the final page footer, place an unbound control where it should display. Set each of these controls Visible properties to No. (Do not disturb the controls you want to normally display at the bottom of each page. Next code the Report's Page Footer Format event: If [Page] = [Pages] Then [PageFooterControlName1] = [ReportFooterControlName1] [PageFooterControlName1].Visible = True ' Do the same for each other ReportFooter control you wish to show in the Page Footer. End If If you have other controls in the page footer that you do not wish to display on the final page, set them to Not Visible in the Page Footer event. You must leave enough Page Footer Height to print these controls. I see no reason you can't stack these controls on top of your regular page footer controls and turn Visible properties on and off as required. Next code the Report Footer's Format event: Cancel = True Then code the Report Header Format event: [PageFooterControlName1].Visible = False ' Do the same for each other Report/PageFooter control you wish to show in the Page Footer. The Report Footer information should display at the bottom of the report where the Page footer normally does. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|