Results 1 to 2 of 2
  1. #1
    chris.williams is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    94

    Subreport Keep Together troubles

    I have a main form with several subreports. The reports are several pages long. Ideally, I would like to keep a subreport intact and not have it span pages unless there is a great deal of white space.



    However, right now, I would be happy just to have them stay together at all. I have set the Keep Together to "Yes" on all subreports and the main report is set to no. Here is what the report looks like as well as the property settings for each section of the subreports.

    Any help would be appreciated. Thanks...

    Click image for larger version. 

Name:	Screen Shot 2012-09-06 at 7.49.23 PM.png 
Views:	5 
Size:	18.6 KB 
ID:	9070Click image for larger version. 

Name:	Screen Shot 2012-09-06 at 7.50.18 PM.png 
Views:	13 
Size:	4.6 KB 
ID:	9071
    Attached Thumbnails Attached Thumbnails Screen Shot 2012-09-06 at 7.49.05 PM.png   Screen Shot 2012-09-06 at 7.49.13 PM.png  

  2. #2
    chris.williams is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    94
    There are lots of answers out there on the web, but they are all poorly written. I did find this writeup/explanation and it is clear. This is the solution:

    There is a KeepTotgether property for groups, which is not
    useful in this case. The only other KeepTogether is for
    individual sections. This means that each subreport needs
    to be in its own main report section.

    This can be done by creating 5 groups (in Sorting and
    Grouping - View menu) on the same field that is used to sort
    the main report records. (If the main report is unbound,
    group on constant expressions such as =1). Specfy Yes for
    both these dummy group's Header and Footer sections. Then
    put each subreport in a separate group header and footer
    section and set these section's KeepTogether property to
    Yes.

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

Similar Threads

  1. Table Relationship Troubles
    By GSTAR in forum Access
    Replies: 5
    Last Post: 07-09-2012, 11:34 PM
  2. Query troubles.
    By SteveSummers in forum Access
    Replies: 1
    Last Post: 10-26-2011, 07:48 PM
  3. Running Sum Troubles
    By royalrochelle in forum Reports
    Replies: 2
    Last Post: 09-10-2011, 05:13 AM
  4. Query troubles
    By dmullins in forum Reports
    Replies: 0
    Last Post: 10-20-2009, 02:17 PM
  5. Form calculating troubles
    By Ufalufa in forum Access
    Replies: 0
    Last Post: 11-27-2007, 10:36 PM

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