External Email - Exercise Caution

Thanks, Iris and Brad!  I cleaned out the extra media link, but still have two entries in the report - however, noticed that the record has two dimension elements, which will also cause double entries, so I think we have the media piece working.   I dont know of any way to filter for multiple dimensions, unless we were to designate a specific 'element' for reports, which I haven't tried yet...

In any case, for now I  advise users to export to Word and manually clean out unwanted data.

Thanks for your help!  I'm slowly getting better at this....

Kim

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

External Email - Exercise Caution

Don’t you think, just joining id-id would be enough as you already filter on the tableID?

 

 

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

 

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

image.png

 

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.

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.