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:
From:
Kimberly Koons <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Fri, 26 Aug 2022 11:08:04 -0400
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (2174 bytes) , text/html (5 kB)
External Email - Exercise Caution
Perfect! Thank you!
Kim


On Fri, Aug 26, 2022 at 10:25 AM Blochel-Dittrich, Iris <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
{MediaXrefs.PrimaryDisplay} = 1


Von: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> Im Auftrag von Kimberly Koons
Gesendet: Freitag, 26. August 2022 16:20
An: [log in to unmask]<mailto:[log in to unmask]>
Betreff: Crystal formula for primary image only

External Email - Exercise Caution
I am running a Crystal report for outgoing receipt that runs from the Loans module, and pulls in tombstone information and a thumblob for inked loan objects.

If an object record has more than one media attached (eg 5 media attached0 the report is repeating object entries in the report (eg 5 times).

The image piece is a subreport, with current formulas:

{vgsrpMediaImageS_RO.ID} = {?Pm-Objects.ObjectID} and
{vgsrpMediaImageS_RO.TableID} = 108

Does anyone know how to add a formula that will only pull the Primary image?

thanks,
Kim
--
Kimberly Koons, Museum Collections Officer
Division of Museum Services
National Archives & Records Administration
700 Pennsylvania Ave., NW
Washington, D.C.    20408
NARA mobile: 301-832-0321
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]<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.


--
Kimberly Koons, Museum Collections Officer
Division of Museum Services
National Archives & Records Administration
700 Pennsylvania Ave., NW
Washington, D.C.    20408
NARA mobile: 301-832-0321

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