I'm running a sports day, and I have a table with 2 fields-events and competitors. I need to print a report of competitors grouped by event, but each event must be on a separate page.
i assume the query driving the report is sorted on "event"
insert a group header or footer for "event"
one of the properties for the header or footer is "force new page" and you get options before or after, so you can easily get a new page to suit what you want