{"id":95,"date":"2009-12-17T10:24:43","date_gmt":"2009-12-17T15:24:43","guid":{"rendered":"http:\/\/wukenny.host-ed.net\/?p=95"},"modified":"2009-12-17T10:24:43","modified_gmt":"2009-12-17T15:24:43","slug":"access-how-to-print-a-report-footer-at-the-end-of-the-last-page","status":"publish","type":"post","link":"http:\/\/kennywu.info\/?p=95","title":{"rendered":"Access: How to print a report footer at the end of the last page."},"content":{"rendered":"

In MS Access, a report footer only shows at the end of the report, not the end of last page. In my Microsection report, I want a fixed height signature area to be at the end of last page. In that way it just looks professional.<\/p>\n

Microsoft KB 208979 introduced three methods to achieve it.<\/p>\n

  • Place the information in the report\u00e2\u20ac\u2122s page footer, which is always printed at a fixed location. (really not what I want)<\/li>\n
  • Set the report properties for the footer section. (the one I used)<\/li>\n
  • Set the report properties for the detail section. ( have not had a chance to try it)<\/li>\n

    The 2nd method is the one I used, it involves using the repot\u00e2\u20ac\u2122s MoveLayout<\/strong>, PrintSectoin<\/strong>, and NextRecord<\/strong> properties.
    \nCreate a function named SetGrpFtrLoc in the repot\u00e2\u20ac\u2122s module section.<\/p>\n

    Function SetGrpFtrLoc(Rpt as Report, GrpFtrLoc as Double)
    \nGrpFtrLoc=GrpFtrLoc*1440 'Convert from inches to twips.
    \nIf Rpt.top < GrpFtrLoc Then 'Not at location yet, so
    \nRpt.movelayout = True 'move to next print location.
    \nRpt.nextrecord = False 'Do not go to next record.
    \nRpt.printsection = False 'Do not print the section.
    \nEnd If 'Until the required offset is reached
    \nEnd Function<\/code><\/p>\n

    Create a dummy group and set it to \u00e2\u20ac\u0153One to Many\u00e2\u20ac\u009d relation so that all sections will show up. Set the dummy group to be the very top level in the \u00e2\u20ac\u0153grouping and sorting\u00e2\u20ac\u009d of the report and show only the footer of the dummy group. Set the dummy footer properties as follow:
    \nHeight: 0.3 in. (or the height of the signature area)
    \nForceNewPage : After Section
    \nOnFomat: = SetGrpFtrLoc([Report], 10)
    \n<\/code>
    \nThe parameter 10 indicated that I want the signature area to begin at least 10 inches from the top of the page. The calculation is following: my page margin is 0.25, page footer is about 0.33 and the page is 11 inch high. Some margin need to be preserved between signature area and page footer.<\/p>\n

    Different ways to achieve this can be found at various forums, but I found the one from Microsoft KB is the most straight forward one.<\/p>\n

    You can not add report footer if you go this way! The footer will appear after the end of group footer.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

    In MS Access, a report footer only shows at the end of the report, not the end of last page. In my Microsection report, I want a fixed height signature area to be at the end of last page. In … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[13,30,50],"class_list":["post-95","post","type-post","status-publish","format-standard","hentry","category-database","tag-access","tag-footer","tag-report"],"_links":{"self":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts\/95","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=95"}],"version-history":[{"count":0,"href":"http:\/\/kennywu.info\/index.php?rest_route=\/wp\/v2\/posts\/95\/revisions"}],"wp:attachment":[{"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/kennywu.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}