This is great, Yer!  What is the SQL for the yuag_objprimarymediapath view?

Thanks again, Rob

From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Vang-Cohen, Yer
Sent: Thursday, September 26, 2019 2:40 PM
To: ListServ tmsusers <[log in to unmask]>
Subject: Re: SSRS Report with Large Image and Object Number

CAUTION:This email originated outside the Institution. Unless you recognize the sender and know the content is safe, do not follow guidance, click links, or open attachments.
Hi Rob,

This is only for the primary image for each object, I'm also using a view I've created, but let me know if you have any questions.

Best,
Y

Yer Vang-Cohen
Data and Database Administrator
Information Technology
Yale University Art Gallery
T: 203-436-9563 | [log in to unmask]<mailto:[log in to unmask]>
http://artgallery.yale.edu/<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fartgallery.yale.edu%2F&data=02%7C01%7CMorganR%40si.edu%7C2298da86b89942aaa03a08d742b10b28%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637051200484467766&sdata=a01a7ZFRtnPx8kUGV4bZSDtkVdUJC9XsnyBaeIjHjzY%3D&reserved=0>


From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Morgan, Rob
Sent: Thursday, September 26, 2019 2:33 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: SSRS Report with Large Image and Object Number

Hello everyone,

Does anyone have a SSRS report with a large primary image and the object number?

Thanks,
Rob Morgan
IT Specialist in Data Management and Systems Administration
Office of the Chief Information Officer
Smithsonian Institution
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.

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.