Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Repeat Column Heading on Mult Col Report (2000)

    Hello,
    I have a report that is just listing 2 fields, DateWorked and HoursWorked so I want to list 2 columns on a single page. The data lists fine, but I can't get the Page Header Labels to repeat above each column. I've tried various things and I just can't get it. Can anyone help?
    Thanks,
    Deb

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

    Re: Repeat Column Heading on Mult Col Report (2000)

    You have two options.

    One option is to add a dummy group header to the report. In the Sorting and Grouping window, add a group level with a dummy expression =1, and set Group Header to Yes. In the Properties window, set the Repeat Section property to Yes, and in Page Setup, Columns tab, set the printing order to Down, then Across.Put the controls you want to appear at the top of each column in the group header.

    The other option is to duplicate the controls in the Page Header section. Unfortunately, you'll have to position the duplicates by trial and error.

  3. #3
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repeat Column Heading on Mult Col Report (2000)

    I was afraid of that. Thank you very much.

    Deb

Posting Permissions

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