Content-Type: |
multipart/alternative;
boundary="_000_21a6e32dca82434a891208fd90b83725jmbmail02JMBERLINDE_" |
Date: |
Fri, 26 Aug 2022 14:25:20 +0000 |
Reply-To: |
|
Subject: |
|
From: |
|
Message-ID: |
|
In-Reply-To: |
|
MIME-Version: |
1.0 |
Sender: |
|
Parts/Attachments: |
|
|
External Email - Exercise Caution
{MediaXrefs.PrimaryDisplay} = 1
Von: The Museum System (TMS) Users <[log in to unmask]> Im Auftrag von Kimberly Koons
Gesendet: Freitag, 26. August 2022 16:20
An: [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] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|
|
|