Results 1 to 3 of 3
  1. #1
    Mister-B is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    31

    Report Bottom of Page

    Hi,



    this is probably something obvious that I just can't get to work. I have a report with a subreport on it. I have data at the top of the report and data below the subreport. Everything is fine as long as the report fits onto one page. If the subreport contains so many records that it spills over onto a second page, the data below the report is printed on every page. If I move the fields in the designer view from the page end to report end, The data below the subreport is printed at the top of a new page after the subreport. This happens even if there is more than enough room for the data directly following the sub report. I would like this data to be printed at the bottom of the last page containing data and not on a separate page. Am I doing something wrong?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,524
    the subreport should be in the DETAIL BODY of the report.
    not page footer,
    not report footer.

    is this your design?

  3. #3
    Mister-B is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    31
    Yes, the sub report is in the Detail Body. I would like the data in the footer to be at the end of the page where the subreport ends and not on a separate page.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-25-2017, 11:02 AM
  2. Replies: 2
    Last Post: 02-04-2016, 08:13 AM
  3. Replies: 1
    Last Post: 11-15-2014, 12:29 PM
  4. How to force Page Footer to the bottom of report
    By nightangel73 in forum Reports
    Replies: 1
    Last Post: 06-20-2014, 11:46 AM
  5. Replies: 1
    Last Post: 04-15-2013, 10:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums