Try grouping on one of the object fields (ObjectID, or SortNumber) and then adding a new section to that group, and put the value there - if there's only one value, it should be fine and not get mixed up with the components. Sometimes you can finess a problem like this by suppressing the section or file using the formula ObjInsurance.ObjectID = previous(ObjInsurance.ObjectID) but Crystal won't do that more than twice. If you have more than one insurance value (we sure do) then you have to create a view that only pulls the most recent one. Hope that is of some help. From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll Sent: Monday, May 15, 2017 3:52 PM To: [log in to unmask] Subject: Crystal Report question: components and current value Good afternoon, colleagues! Is there a way to fashion a Crystal Report for records that have components, but have the current value print out for just the main record? The report I have prints out the current value as many times as there are components. For example, a clock composed of seven components (Component Type=Part of an object) prints out the overall value seven times! Not what I want when totaling up insurance values. I could change the Component Type to Accessory, and then limit the report in the Select Expert to Component Type=Part of an object, but not all components are accessories; some are a part of an object. Any ideas would be most appreciated. Christine Christine Droll Registrar, Database and Collections The Nelson-Atkins Museum of Art 4525 Oak Street Kansas City, MO 64111 T: 816-751-1333 F: 816-751-0499 [log in to unmask]<mailto:[log in to unmask]> To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.