Dimitry at Gallery Systems created the CR attached, which produces an illustrated checklist that can be saved in Excel, as a PDF, or in Word; it doesn't sort (at least not for me).
Laura
Laura Coyle
Collection Manager
Smithsonian National Museum of African American History and Culture
600 Maryland Avenue, SW Suite 7001
Mail: MRC 509 PO Box 37012
Washington, DC 20013-7012
Telephone: 202.633.0249
Fax: 202.633.4816
Email: [log in to unmask]
Web: nmaahc.si.edu
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Kate Blanch
Sent: Friday, March 25, 2011 1:39 PM
To: [log in to unmask]
Subject: Checklists and Sorting Images in Excel
Hi all - This is more an Office conundrum than TMS question but since I know we all appreciate a good checklist...
I've created a custom Crystal report in TMS that is a checklist. I have gotten the data and the ThumbBLOB (thumbnail) to export to Excel while maintaining the integrity of the grid (no extra columns, blank rows or alignment issues occur). The issue is that when sorting the Excel spreadsheet - the images don't sort with their associated rows. The data sorts great.
Everyone here seems to have a different wives tale as to how to make the images sort with the cells and none work consistently...do you all have any tricks that could inform this issue? Ideally the solution would be some formatting thing we could apply to the whole worksheet (and not have to adjust each image's properties, individually).
Thanks in advance and have a super weekend!
Kate Blanch
Administrator, Museum Databases
[log in to unmask]<mailto:[log in to unmask]> / 410.547.9000 ext. 266
The Walters Art Museum
600 N. Charles Street, Baltimore MD 21201
www.thewalters.org<http://www.thewalters.org/>
Treasures of Heaven: Saints, Relics and Devotion in Medieval Europe<http://thewalters.org/eventscalendar/eventdetails.aspx?e=1568> February 13-May 15, 2011
Realistic Perfection: The Making of Oriental Ceramic Art<http://thewalters.org/eventscalendar/eventdetails.aspx?e=1783> March 12-June 4, 2011
Relics and Reliquaries: Reconsidered<http://thewalters.org/eventscalendar/eventdetails.aspx?e=1936> February 26-May 22, 2011
[cid:image001.png@01CBEAF3.96901A90]<http://twitter.com/walters_museum> [cid:image002.png@01CBEAF3.96901A90] <http://www.facebook.com/pages/Baltimore-MD/The-Walters-Art-Museum/6634368191?ref=ts> [cid:image003.png@01CBEAF3.96901A90] <http://www.flickr.com/photos/walters-art-museum/sets/>
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.