Results 1 to 3 of 3
  1. #1
    dkrumholz is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2012
    Posts
    4

    Column Headings For Details With Group Headers and Multiple Detail Pages

    I have a report with a fairly large group header section followed by multiple pages of details followed by another group header, etc. I need column headings above the detail for each page. If i put the column headings in the page header section then I need to supress the page header whenever I print the group header because the group header has the column headings for the start of the detail. Any suggestions on how to solve the problem? The output I want is shown below:

    page 1 -
    Group Header Row 1
    Group Header Row 2


    Group Header Row n

    Column Labels (in the group header?)
    as many detail rows as fit on this page

    page 2 -
    Column Labels
    a full page of details

    page 3 -
    Group Header Row 1
    Group Header Row 2
    Group Header Row n

    Column Labels (in the gorup header)
    as many detail rows as fit on this page

    page 4 -
    Column Labels
    a full page of detail rows

    page 5 -
    Column Labels
    a full page of detail rows

    and so on

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    dkrumholz is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2012
    Posts
    4

    Suppress page header on group header page

    Quote Originally Posted by June7 View Post
    That page seemed to have the wrong answer but it gave me enough clues to determine a good method -

    In the groupheader format event turn the pageheadersection.visible to true so the page header prints for pages after the group header. In the group footer format event turn the pageheadersection.visible to false so the page header does not print at the top of the next page which has the group header.

    Thanks!

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

Similar Threads

  1. Group Headers Not Repeating in a Report
    By kristyspdx in forum Reports
    Replies: 4
    Last Post: 12-20-2011, 05:00 PM
  2. csv import second row contains column headings
    By dr_patso in forum Import/Export Data
    Replies: 1
    Last Post: 07-16-2011, 03:56 PM
  3. Cross Tab Column Headings...
    By mhoctober in forum Queries
    Replies: 3
    Last Post: 09-10-2010, 01:21 PM
  4. columns for group detail but not group header?
    By Coolpapabell in forum Reports
    Replies: 0
    Last Post: 08-21-2009, 08:53 AM
  5. Hide Duplicates with Group Headers
    By diwin in forum Reports
    Replies: 0
    Last Post: 03-26-2009, 09:32 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