External Email - Exercise Caution

Thank you Brad this is really helpful!!   In our report, we added the image via a subreport, so did not have to do as much table linking, but this is still very useful!

Regards,
Kim

On Fri, Aug 26, 2022 at 12:11 PM Blochel-Dittrich, Iris <[log in to unmask]> wrote:

External Email - Exercise Caution

Mine look like this. The main reports links to the subreport object.id <-> MediaXrefs.ID

 

 

Von: The Museum System (TMS) Users <[log in to unmask]> Im Auftrag von Brad Hubley
Gesendet: Freitag, 26. August 2022 17:58
An: [log in to unmask]
Betreff: Re: Crystal formula for primary image only

 

External Email - Exercise Caution

I’ve created a report that runs from the Objects module that displays just the primary image even if the object has more than one image.  In the report I group on Object.Id and in Select Expert I have: {vgsrpMediaXrefsS_RO.PrimaryDisplay} = 1

 

Here are my joins:

 

 

 

 

Hope this helps.  Let me know if you’d like a copy of my report; you would of course have to modify it to run in the Loans module.

 

 

Das Bild wurde vom Absender entfernt.

Brad Hubley
Technician, Entomology & TMS

100 Queen's Park
Toronto, ON M5S 2C6
416 586 5764

 

Royal Ontario Museum is an agency of the Government of Ontario.ROM acknowledges that this museum sits on what has been the ancestral lands of the Wendat, the Haudenosaunee Confederacy,and the Anishinabek Nation, including the Mississaugas of the Credit First Nation, since time immemorial to today.

Le Musée royal de l'Ontario est un organisme du gouvernement de l'Ontario.Le ROM reconnaît que le Musée est situé sur les terres ancestrales des Wendats, de la Confédération des Haudenosaunee et des Anishinabes, y compris la Première Nation des Mississaugas de Credit, et qu’ils occupent ces terres depuis la nuit des temps.

 

From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Kimberly Koons
Sent: Friday, August 26, 2022 11:14 AM
To: [log in to unmask]
Subject: Re: Crystal formula for primary image only

 

[EXTERNAL EMAIL] DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe.

External Email - Exercise Caution

Hm.  Spoke too soon.  Still repeating - 2 entries (better than 5!). Maybe how new table (Media XRefs) is linked  - out of the box, 2 links, both inner joins...

(I freeze at the mere mention of 'joins...')

 

On Fri, Aug 26, 2022 at 11:08 AM Kimberly Koons <[log in to unmask]> wrote:

Perfect! Thank you!  

Kim

 

 

On Fri, Aug 26, 2022 at 10:25 AM Blochel-Dittrich, Iris <[log in to unmask]> wrote:

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] 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.


 

--

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


 

--

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.

The Museum is now open and we are delighted to welcome you back. For more details and helpful information for planning your visit, please visit www.rom.on.ca


Le Musée a rouvert ses portes et nous sommes ravis de vous accueillir de nouveau. Pour en savoir plus et bien planifier votre visite, veuillez consulter www.rom.on.ca/fr

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.

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.



--
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.