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.