Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Output (2003)

    I've got a query that returns 4 results like so...

    Name, Contract, Amount
    John Doe, 12345, 34.49
    John Doe, 12345, 144.38
    John Doe, 12345, 4.49
    Mike Smith, 19473, 5.00

    I then have a report where I would like to display the each user on it's own page. So report page 1 would have 3 entries for John Doe and the 2nd report page would have Mike Smith. My darn report produces 4 pages (one for each record). What can i do to solve this. Any input would be much appreciated. Thanks in advance!!

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

    Re: Report Output (2003)

    In the Sorting and Grouping window, enter the Name or Contract field and set the Group Header property to Yes.
    You can give the group header a height of 0 if you don't want to put any controls in it.
    Set the Force New Page property of the group header section to Before Section.

    Make sure that the Force New Page property of the Detail section is set to None.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Output (2003)

    Hi Hans,

    That got all the results to one page, but my headings are repeating. This is what page 1 looks like. Thanks again!

    Amount
    34.49

    Amount
    144.38

    Amount
    4.49

    It should display like so...
    Amount
    34.49
    144.38
    4.49

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

    Re: Report Output (2003)

    Put the Amount label in the group header, instead of in the detaiul section.

  5. #5
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Output (2003)

    You rock, Thank you!!

Posting Permissions

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