Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reports (MS Access 2000)

    I have a report that is broke into groups, with people address information listed beneath their particular group. But instead of listing them in a column below the group title I would like them listed 3 across like labels. Example below

    GROUP
    Bill Smith Joe Smith Kevin Smythe
    123 east 456 west 789 north
    city, st city, st city, st

    Thanks in advance

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

    Re: Reports (MS Access 2000)

    If you want each group to begin on a new page, you can create a report with 3 columns, to be printed across then down. Group the report by the field you want, but put the header information in the page header instead of in the group header.

    If you don't want each group on a new page, you'll need to create a one column report that displays the grouping levels, and a three column subreport that displays the addresses, across then down.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports (MS Access 2000)

    Thanks Hans, works great!!

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports (MS Access 2000)

    Well Hans I thought it working perfectly! Except one major problem I didn't notice at first. In the first group I have 44 People, so I this group prints 44 times, before its goes to next group. I assume that this is because the primary report is printing the grouped subreport, in this case based on YearsAMember, for each record. How do I get the Group Header to only print once? ANd then get the next Group Header to print following the previous group without going to next page. And when a group has to carry over to another page the group heading is printed again on the subsequent page. Whew - what a keyboard full! Thanks again for your help!

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

    Re: Reports (MS Access 2000)

    Which design from my previpus are you using? The first or the second?

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports (MS Access 2000)

    The second, 3 column sub report. I have nothing in Page Header, I have the grouping criteria (YearsAMember) in Group Header, and I have the sub-report (center information) in the detail area.

    Thanks shihalud

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

    Re: Reports (MS Access 2000)

    Thanks. In that case, try putting the subreport in the group header, below the controls you already have there, and leaving the detail section empty (you can set its height to 0).

  8. #8
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Arlington, Texas, USA
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports (MS Access 2000)

    Thank you Hans - this did the trick.

Posting Permissions

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