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.