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:
Re: Crystal Report question: components and current value
From:
"Smith, Jeffrey" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Mon, 15 May 2017 20:25:10 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (2158 bytes) , text/html (6 kB) 
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.

ATOM RSS1 RSS2