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:
Danielle Uchitelle <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Wed, 18 Jan 2017 16:44:20 +0000
Content-Type:
multipart/related
Parts/Attachments:
text/plain (3506 bytes) , text/html (10 kB) , image001.jpg (10 kB) , image002.jpg (10 kB)
Adam, you are correct; the best way that I have found to work around the image display limitations of Crystal is to use the image size metadata to calculate the desired size and aspect ratio in your reports.

A simpler approach is to use the thumbnail image in reports rather than the full-size image, as thumbnails should all be generated at the same size.  But I understand that there are times when you’ll want to display the full-size image instead.

I also agree that this is one of the compelling reasons to try SSRS as an option for TMS reporting, as SSRS does not have Crystal’s limitations on image handling.

Best,
Danielle Uchitelle

________________________________
Danielle Uchitelle | Chief Operating Officer
[log in to unmask]<mailto:[log in to unmask]> | 646.733.2239 x264
GallerySystems | www.gallerysystems.com<http://www.gallerysystems.com/>

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Pogány Ádám
Sent: Wednesday, January 18, 2017 6:52 AM
To: [log in to unmask]
Subject: Re: Correctly formatting images in Crystal Reports

Hi Rupert,

My workaround for this was to pull the width and height data of the picture from TMS, put the OLE into a subreport and use functions to compute the X and Width parameters in Object size and position, based on the box's size.

I haven't find a better solution yet.

(Lack of) image handling is one of the main reasons I'm thinking about moving from CR to SSRS for reporting.

Best,
Adam
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Shepherd, Rupert
Sent: Tuesday, January 17, 2017 2:15 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Correctly formatting images in Crystal Reports

Dear colleagues

I've inherited a Crystal Report that pulls large images into the report based on path and filename. However, these images are of differing proportions (some landscape, some portrait, etc.), and are therefore are distorted so that they completely fill the box on the report occupied by the image OLE object. Is there any particular set of settings in the report that will show the images in their correct proportions?

With thanks and bets wishes

Rupert

Rupert Shepherd, PhD FSA
Collection Information Manager
[log in to unmask]<mailto:[log in to unmask]>
Tel: +44 (0)20 7747 5921

[A képet a feladó eltávolította. The National   Gallery, Trafalgar Square, London WC2N 5DN]<http://www.nationalgallery.org.uk>
[A képet a feladó eltávolította. Australia’s Impressionists exhibition]<http://www.nationalgallery.org.uk/whats-on/exhibitions/australias-impressionists>
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.

ATOM RSS1 RSS2