You have to set each image to "Move and size with cell" - otherwise the
image just floats over the cell instead of being tied to the row.

Why not just apply a sort parameter to the report, and manage it there
instead of in the Excel? Have you thought about doing the same only with the
XSLT in the dataviews, instead of CR?

~Chad

On Fri, Mar 25, 2011 at 11:20 AM, Melisa Lujan <[log in to unmask]> wrote:

>  Kate,
>
>
>
> In terms of excel spreadsheets, I seem to recall that you need to insert
> each image individually into each cell (not cut and paste or copy) in order
> for image to be read as “data” contained in that cell. Then it will sort
> with the cell. However, I also seem to remember that you have to make sure
> the cell is larger than the image or else the image will not sort as well.
> If the image goes over to another cell it can’t read which cell the image is
> attached to and does not sort. Again this is what I remember from doing
> checklist with images in excel, which I haven’t done in a while. Not sure
> when you export checklist with images from TMS if image is “read” as data in
> cell but I don’t believe it is. It is sort of just copied into right cell,
> which is why is probably doesn’t sort.
>
>
>
> Also, you should try incoroproating sort features in TMS reports so you
> don’t have to resort checklist once exported; you would sort in TMS. However
> I know I lack the skills in CR to create or incorporate such features in my
> checklists so this may not be an option for you.
>
>
>
> Hope this helps.
>
>
>
> Melisa
>
>
>
> [image: cid:image001.gif@01CA4BF9.8F99ED50]
>
>
>
> *Melisa Lujan *Registrar
> 212.660.7131 / 212.831.7927 Fax / [log in to unmask]
>
> *El Museo del Barrio*
> 1230 Fifth Avenue at 104th Street, New York, NY 10029
> www.elmuseo.org
>
> » This Week @ El Museo <http://www.elmuseo.org/en/at-el-museo>
> » Become a member<http://www.elmuseo.org/en/content/get-involved/benefits-membership/overview>
>
> This message is intended only for the use of the individual or entity to
> which it is addressed and is covered by the Electronic Communications
> Privacy Act, 18 U.S.C.2510-2521. This message is legally privileged and
> confidential and may contain information that is privileged, confidential
> and exempt from disclosure under applicable law. If the reader of this
> message is not the intended recipient, or the employee or agent responsible
> for delivering the message to the intended recipient, you are hereby
> notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. E-mail transmission cannot be
> guaranteed to be secured or error-free as information could be intercepted,
> corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.
> If you have received this communication in error, please notify us
> immediately by sending an email to *[log in to unmask]*<[log in to unmask]>,
> and delete the original message, and all copies, from your system.
>
>
>
>
>
> *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] <[log in to unmask]> / 410.547.9000 ext. 266
>
>
>
> The Walters Art Museum
>
> 600 N. Charles Street, Baltimore MD 21201
>
> 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
>
> [image: Twitter logo] <http://twitter.com/walters_museum>   [image:
> Facebook logo]<http://www.facebook.com/pages/Baltimore-MD/The-Walters-Art-Museum/6634368191?ref=ts>
>    [image: Flickr logo]<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.
>  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.
>

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.