Results 1 to 2 of 2
  1. #1
    Stressed is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    19

    Keep subreport header and details together at all times.

    I have a main report with 9 sub reports. Each sub report is set to grow and shrink depending if there is data.



    What is happening is that when there is a lot of data in one subreport, it pushes the next subreport down so that the header appears at the bottom of the page and then the detail starts on the next page.

    Is there a method to keep the header and details together at all times?

    I know that you can have the header row repeat but I don't want it at the bottom of one page without any detail.

    I've searched and haven't found any solutions.

  2. #2
    Stressed is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2010
    Posts
    19

    Fix

    Ensure "Force New Page" is set to No in the Properties section of details.

    In the Sorting and Grouping section of the report, select Keep Together "With First Detail"

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

Similar Threads

  1. Multiple Details Sections of report
    By nkuebelbeck in forum Reports
    Replies: 1
    Last Post: 03-17-2010, 09:34 AM
  2. Report and Subreport
    By newbie in forum Reports
    Replies: 0
    Last Post: 02-16-2010, 12:14 PM
  3. Subreport Calculation field
    By Cheshire101 in forum Reports
    Replies: 2
    Last Post: 01-14-2010, 05:50 PM
  4. Replies: 26
    Last Post: 11-06-2009, 10:16 AM
  5. Show Hide Subreport / acViewReport
    By BigBear in forum Reports
    Replies: 4
    Last Post: 03-30-2009, 06:07 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