TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Kate Blanch <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Fri, 25 Mar 2011 13:39:10 -0400
Content-Type:
multipart/related
Parts/Attachments:
text/plain (1955 bytes) , text/html (8 kB) , image001.png (8 kB) , image002.png (8 kB) , image003.png (8 kB)
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

  <http://twitter.com/walters_museum>     
<http://www.facebook.com/pages/Baltimore-MD/The-Walters-Art-Museum/66343
68191?ref=ts>     
<http://www.flickr.com/photos/walters-art-museum/sets/> 

 

 

 


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.


ATOM RSS1 RSS2