Ma'am;

I am not sure if you have access to the SQL backend, but if you do then you can run this query and export the results to excel. Or you can make it a view and create a list view and use it that way.


regards,

Ron Auxier

THE MUSEUM OF FINE ARTS, HOUSTON
5100 Montrose Boulevard
Houston, Texas 77006
Phone: 713-353-1509
[log in to unmask]

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Diane Lee
Sent: Thursday, August 01, 2013 10:04 AM
To: [log in to unmask]
Subject: Report/Listview help?

Hello all -

Forgive me if I've asked this question before, but I checked the archive and didn't see anything.
We've recently gotten an image server of sorts, and I've been updating our Media records with the current archival image information so staff can retrieve archival images as needed. The one thing that seems to be clunky is getting TMS to spit out a list of where the archival images live. We currently have to go into each record and go through all the clicks to get to the Archival Storage tab on the filename for each one. We note the folder location of the image in the Archival Volume Name field, and I can't see to find a listview or report that includes this field anywhere.

So, my question is, does anyone have a report or listview (so they export to an Excel sheet) that includes this field? I am on 2010, and do not have Crystal Reports to create my own at this point. (Or am I missing an obvious shortcut??)

Any help or suggestions would be great! Thanks!

Diane.


==================================================================
Diane Lee | Collections Manager
[log in to unmask]<mailto:[log in to unmask]> | (860) 236-5621 x(242)
Connecticut Historical Society | One Elizabeth Street | Hartford, CT 06105 | www.chs.org<http://www.chs.org/>

Upcoming Events<http://www.chs.org/calendar> | Membership<http://www.chs.org/membership> | Donate<http://store.chs.org/donate/> | Volunteer<http://www.chs.org/volunteer>
Visit us on Facebook<http://www.facebook.com/CTHistoricalSociety> and Twitter<http://twitter.com/connhistsoc> @ConnHistSoc


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.