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?
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.
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.