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.

 

 

 

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]

 

 

 

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.