Results 1 to 2 of 2
  1. #1
    Ganymede is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Dec 2011
    Posts
    116

    How to repeat subreport header after first page of subreport

    I have a report with a subreport. The subreport has a page header (not a report header). And I have the "Show Page Header and Page Footer" property set to yes. So the header appears on the first page of the subreport as expected. But it does not appear on any subsequent pages. I need the subreport header to appear on all subsequent pages.



    In researching this, I have found that the common solution is to create a dummy group, put the subreport header in the header for the dummy group, and set the dummy group header to repeat.

    But I that solution does not works for me. Here's how my report is currently structured (I don't think I need to wrap this in code but I will out of an abundance of caution):

    Code:
    Report header: blank
    Page Header: blank
    Group 1 Header: Main report header
    Group 2 Header: blank
    Detail: Main report data
    Group 1 Footer: Contains the sum of one of the fields in the "Detail" seciton
    Group 2 Footer: contains my subreport w "Force New Page: Before & After"
    Page Footer: blank
    Report Footer: blank
    I structured it this way because (1) I needed a group footer for the "Sum" filed in my main report, and (2) I needed to put the subreport in a footer so that the subreport would appear after the main report and I could force a page break with the "Force New Page" feature.

    If I add a new group (Group 3), the header will appear between Group 2 and Detail. So if I put the subreport header in the Group 3 header, it'll just appear above the detail section.
    Code:
    Report header: blank
    Page Header: blank
    Group 1 Header: Main report header
    Group 2 Header: blank
    Group 3 Header:
    Detail: Main report data
    Group 1 Footer: Contains the sum of one of the fields in the "Detail" seciton
    Group 2 Footer: contains my subreport w "Force New Page: Before & After"
    Page Footer: blank
    Report Footer: blank
    Does anyone have any proposed solutions? I would greatly appreicate any assistance.

  2. #2
    Ganymede is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Dec 2011
    Posts
    116
    I figured it out. The dummy group has to go in the subreport--not the main report. Marking as resolved.

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

Similar Threads

  1. Repeat Group Header, but NOT on Subreport
    By laniebe in forum Reports
    Replies: 0
    Last Post: 04-28-2017, 02:09 PM
  2. Replies: 4
    Last Post: 04-19-2017, 09:36 AM
  3. Replies: 13
    Last Post: 06-13-2014, 03:25 PM
  4. Replies: 30
    Last Post: 08-15-2012, 02:25 PM
  5. Replies: 3
    Last Post: 08-07-2011, 09:22 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