Hello Lucille, If you haven't received anything else yet, here's a very simple and very customizable report regarding your request below. the trick to eliminating duplication of artists' names, is to group the report by the artist ID number field (not by name, not as sure). The parameters in it can be used to narrow down your search, but none are in use now. Let me know if you need something else on this. I hope this helps out a little. thanks, Lisa Louisa Gutierrez, Assistant to the Registrar Naples Museum of Art 5833 Pelican Bay Blvd. Naples, FL 34108 (239) 254-2624ph (239) 254-2753fax [log in to unmask] <mailto:[log in to unmask]> ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Lucille Stiger Sent: Friday, October 16, 2009 11:39 AM To: [log in to unmask] Subject: Is there a Crystal Report that.... Hi Everyone, I have been requested to provide a list of all the artists represented in our collection. Does anyone have a report that will do this without duplications? Ideally, it will include the artist's nationality and his/her dates. Much obliged! -- Lucille Stiger Registrar Allen Memorial Art Museum 440.775.8668