Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jun 2003
    Location
    Washington, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report - GroupHeader - Repeat Section = Yes (Access 2k)

    I have a report that contains 5 subreports, with 1group header. The problem is when the Repeat Section = Yes - it does repeat the headers for all my groupings except for the last grouping creates hundreds of extra pages.

    I have played around with the Group Header settings and pin-pointed my problem to the above mentioned.

    Does anyone have any suggestions or workarounds?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report - GroupHeader - Repeat Section = Yes (Access 2k)

    Do you have a text box with a control source like ="Page " & [Page] & " of " & [Pages] in the report header or footer? If so, remove [Pages] to see if that helps.

    Have you also tried varying the Force New Page property of the various sections of the report?

  3. #3
    Lounger
    Join Date
    Jun 2003
    Location
    Washington, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report - GroupHeader - Repeat Section = Yes (Access 2k)

    Not in Report footer - however in the Page footer - I have the standard Page: Page of Pages.

    The report function properly without the Repeat section on the Group Header(however, I would prefer to have the group header on each page of the report- Is there another way to force the Group header or a txtboxt that thinks it is a group header to be displayed on each page of the report.

    Yes I have played with the Force New Page properties on the various sections - My report has the following sections.

    Page header
    Office Header
    Detail
    Page footer.

    Any suggestions is greatly appreciated.

    Karen

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report - GroupHeader - Repeat Section = Yes (Access 2k)

    Sorry, I meant Page Footer instead of Report Footer. Have you tried removing [Pages] temporarily to see if that helps?

  5. #5
    Lounger
    Join Date
    Jun 2003
    Location
    Washington, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report - GroupHeader - Repeat Section = Yes (Access 2k)

    yes I did with no affect.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report - GroupHeader - Repeat Section = Yes (Access 2k)

    Sorry, no idea. You can post a stripped-down copy of the database, if you like.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •