Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report sort and group (A2k3, SP1)

    Hi All,
    I'm having trouble grouping the attached report. As you can see in the table there are 2 Draw Agencies; 1 with 2 clients and the other with 1. Shouldn't I be able to group these in the report so that 2 copies of the report are printed? 1 report with the 1st Draw Agency & 2 clients and the 2nd report with other Draw Agency & the 1 client.
    I haven't run into this problem before so I am obviously setting something wrong.
    Thank you.

    gdr
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

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

    Re: Report sort and group (A2k3, SP1)

    You haven't grouped the report at all. Open the report in design view and activate the Sorting and Grouping window. Click in the DrawAgencyPKID box, then set both Group Header and Group Footer to Yes.
    Move all controls from the page header to the group header, and reduce the height of the page header to zero.
    Move all controls from the report footer to the group footer, and reduce the height of the report footer to zero.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report sort and group (A2k3, SP1)

    Hi Hans,
    Thanks a bunch.
    Cripes. I knew that....I guess I am brain dead. <img src=/S/newbrain.gif border=0 alt=newbrain width=21 height=22>
    Too much to do and too little time and too little help*. I don't know if that's an excuse or a reason...... <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>
    Thanks again for your help

    *except for the invaluable help I receive here <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

Posting Permissions

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