Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2004
    Posts
    44

    Unanswered: grouping in a report

    I have a report that details events by location, type, participants, and date. There are also items that can be ordered to go with that event (ex.
    hats, pens, t-shirts). Everything is bound together by EventCode. How can I arrange it so that I have the event description on one line and then the orders that go with that event underneath?

    Event Code
    Description
    Items Ordered

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1

    Re: grouping in a report

    You already have it listed the way you should be grouping. Your main grouping level should be event code. Make a header for that grouping level and put description in it. Then place items ordered in the detail.

  3. #3
    Join Date
    Mar 2004
    Posts
    44
    yes the header is EventCode. Then comes the details for location, participants, and type. I need another grouping level just for the items that go along with the event. There can be 10 different items that go under one event.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Uh... ok...

    EXACTLY what fields do you have, and what order do you need them displayed?

  5. #5
    Join Date
    Mar 2004
    Posts
    44
    Event Code

    Date, Event Type, Description, Participants, Event Cost- on one line because ther will be one event associated with different event items

    Item No, Description, Qty, Price, Amount - on next line with their appropriate headings.

    example of how i would like it:

    JG0032 (EventCode)

    Location Type
    PGA National Golf Club Golf Tournamant

    Item No Description Price Qty
    6-PR-03 Golf Tees 2.85 8

    Next item here

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Oh, discription is for the items. I though description was a description for the event. Also, eventCode probably has more then one event associated with it?

    If that's the case, make your first grouping eventcode, so it would be like this:

    EventCode
    ....Location, Type, Name
    ........Item Detail (item no, description, price, qty)
    ....location footer - total cost probably

Posting Permissions

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