I'm trying to build a report of "artist payout invoices" to print when our arts center cuts checks to artists who have sold work. I need one artist to appear on each page, with all their works sold listed on that page.

I have all sold items in GiftShopSalesT that I use for ArtistPaymentInvoiceQ (brief screenshots below).

I'm trying to figure out how to run a report that will print each artist (by personID) on a separate page, and I've hit a wall. The report just smashes it all together.

How can I group all items with the same personID together? I tried "group by" in the report, but that didn't work.

Thank you!