TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Crystal Report question: components and current value
From:
Christine Droll <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Mon, 15 May 2017 19:52:04 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (1077 bytes) , text/html (3565 bytes) 
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.

ATOM RSS1 RSS2