包括访问子报表中的页脚 [英] Including Footers on Subreports in Access
问题描述
我的用户拥有一个数据库，用于存储他们开展业务的规则和要求。例如：财政政策或董事会政策。设置数据库报告的方式，用户可以打印出财政政策手册的标题页，并在单独的报告中打印财政政策手册的目录，在第三个报告中打印财政政策手册的政策。这3份报告合在一起构成了财政政策手册。
我被要求将这3份报告合并为1份报告。我可以使用包含3个子报告的第4份报告来完成此操作。问题是每个报告都有不同的页眉和页脚（特别是页面编号），当我合并报告时，我无法显示子报告的页眉或页脚。如果我在主报表中添加一个标题，我将获得第一个子报表的标题（然后显示重复的标题），但我无法获得其他2个子报表的页眉或页脚。有没有办法强制页眉和页脚显示或隐藏每个子报告？或者有没有办法将页码设置为从第3页而不是第1页开始？
如果您知道更好的方法来实现这一目标，并愿意与我分享，我将非常感谢您的帮助。我很难过。
感谢您阅读我的问题并分享您遇到的任何解决方案。
页面或报告级别页眉/页脚？
我们需要您正在使用的Access版本。
在V2010中，我有一个主要报告，它结合了两个子报告并且它们的标题显示（附），此报告最初是在V2003中制作的。
子报告中的报告标题应该打印。
如果标题信息在页面标题中。然后这些被主要报告所压制。你必须有一个宏，vba或一个控件引用子报告，如（（68.8 KB，1982 views）< td> BytesThread950378_HFinSubRpts_2.jpg （30.8 KB，1771 views）
ZMBD，感谢您提供了良好的信息。我很欣赏你的样本并理解你在做什么。我喜欢将子报告中的总和提取到主报告的链接信息。我以前不知道该怎么做，我会把它添加到我的工具箱中。但是，我正在阅读故障排除，要检查的第一件事是确保总文本框位于报表页脚部分，而不是页面页脚部分。
我的问题是我需要页眉和页脚。报告标题不会重复，每个子报告在多个页面上都有不同的页眉。我不能将页眉放在主报告中，因为子报告的需求是不同的。
报表页脚中页面页面的问题是我只想在第3个子报表上看到它们。我的老板说在手册的标题页上有页码是不专业的。挑剔，挑剔！
我认为这可能是一个失败的原因，但也许有一种方法可以在使用子报告时显示页眉和页脚。如果您有任何其他想法我应该留意，请告诉我。我正在使用Access 2007，但如果Access 2010中有更好的工具，我可以和我的公司谈谈升级到Access 2010.
非常感谢您提供的任何信息甚至如果只是确认无法在Access中完成我需要的东西。
My users have a database that they store the rules and requirements for how they do business in. For example: the Fiscal Policy or Board of Trustees Policy. The way the database reports are set up the user can print out the Title Page for the Fiscal Policy Manual and in a separate report the Table of Contents for the Fiscal Policy Manual and in a third report the Policies for the Fiscal Policy Manual. These 3 reports combined make up the Fiscal Policy Manual.
I am being asked to combine these 3 reports into 1 report. I can do this with 4th report that holds the 3 sub-reports. The issue is that each report has a different header and footer (in particular page numbering) and when I combine the reports I can not get the header or footer of the sub-reports to show. If I add a Header to the main report I am getting the header for the 1st sub-report (which then shows duplicative headers), but I can not get the header or footers for the other 2 sub-reports. Is there a way to force the header and footer to show or hide for each sub-report? Or is there a way to set page numbers to start on page 3 instead of page 1?
If you know of a better way to accomplish this and are willing to share with me I would really appreciate the help. I am stumped on this.
Thank you for reading my problem and sharing any solutions you have come across with me.
Page or report level headers/footers?
We will need the version of Access you are using.
IN V2010, I have a main report that combines two subreports and their headers are shown, (attached), this report was originally made in V2003.
The report headers in the subreports should print.
If the Header information is in the "Page Header" then these are suppressed by the main report. You will have to have either a macro, vba, or a control the refers to the subreport such as in (Allen Browns tip for bringing the totals to the main report
For the page of page... in the main report, page footer, insert text box, set control source to="Page " & [Page] & " of " & [Pages]
So here''s in design view (Sorry, had to cut the right side off due to privacy issues... just the pageofpage thing.)
Here''s a cut and paste of the report. Once again, I had to redact some things due to privacy issues. Notice the "Averages", these are in the individual report headers.
Note the pageofpage is usually something like "1 of 20" the control for this is in the page footer of the main report as are the dates (pulled from the form used for the filter) shown at the bottom of the report.
ZMBD, thank you for the good information. I appreciated your sample and understood what you were doing. And I liked the linked information about pulling the sum from a Sub-report to a main report. I did not know how to do this previously and I will add this to my tool box. However, I was reading the troubleshooting and number 1 thing to check is "Make sure the total text box is in the Report Footer section, not the Page Footer section."
My problem is that I need the page headers and Footers. Report headers don''t repeat and each sub-report has a different page header that is needed on multiple pages. I can''t put the page header in the main report because the needs of the sub-reports are different.
The issue with the Page of Pages in the report footer is that I only want them on the 3rd Sub-Report. My boss says it is unprofessional to have page number on the title page of the manual. Picky, picky!
I think this is probably a lost cause but maybe there is a way to get page headers and footers to appear when using sub-reports. If you have any other ideas that I should look into please let me know. I am using Access 2007 but if there is better tools in Access 2010 for this I could talk my company into upgrading to Access 2010.
Thank you very much for any information you can provide even if it is just a confirmation that what I need can not be done in Access.
这篇关于包括访问子报表中的页脚的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
