I have a report I am running for events with subevents. The report runs off a query where the event code is inputted and the query lists the individual and the subevents they are in.

The output of the query is like this:
EventCode, SubeventName, Name, Address, Phone

The query is a simple select query which lists a registrant and their associated info 4 times if they are in 4 subevents.

On my report, I am showing one person per page, listing their info, and want to list all of the subevents they are in. How can I do this in my report? I am drawing a blank on this.

Thanks in advance for your help.

Group by registrant, move all the "registrant" fields to the grouped section, then all the relevant subevents should show in the detail section.

For some reason it isn't working. I moved all of the registrant info to the page header area and left the subevent field in the detail area but it is still printing four pages....one for each subevent.

Page Header Area is not the Grouped area. You need to use the report's grouping feature, as I mentioned in my previous post.

That is what I had originally.....In the grouping area of the report I had the registrant in the sorting and grouping of the report. The registrant name is the field and sort order is ascending. Group Header is No, Group Footer is No, Group On is Each Value, Group Interval is 1, Keep Together is No.

I am still getting four pages for the report.

Group Header should be set to yes, otherwise how can you put anything in the header? As far as I understand it, you have registrant info for each subevent but only want this displaying once; in order to do this, you group on Registrant and move all the registrant info that would otherwise be repeated into the Group header. Beneath the group header, all the subevents for that particular registrant will be repeated. As long as you don't have any inserted page breaks in your report, or set in the details section, you should be fine.

The rest of your group options are fine, although you can set "Keep Together" to yes to help try and keep all the group details together.

Did what you said but I have the registrant info on the first page and the subevents only are showing on subsequent pages.

Check your Detail section properties. You don't want any page breaks in there. This is how the grouping works;

=================================================
Group Header
---------------------------------------------------------------
Detail Section
---------------------------------------------------------------
Group Footer
=================================================

If your Group Header is filled with Regsitrant Info that doesn't fill your whole first page, then your detail section should start immediately below it. The group footer then follows the detail section. After this you will get the next Registrant Group. Remove ALL Page Breaks from EVERYTHING, and set the Registrant Group properties "Keep Together" as Yes. This is pretty simple, if its not working then you have set something wrong. I tried this myself, and the defaults give you exactly what you want, so you have set some Page Breaks somewhere and are just missing where they are I think.