Hi Everybody,

I'm still working on this. I will try to make it work with both SQL Server and Oracle.

Jay



-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Brenda Podemski
Sent: Thursday, August 23, 2007 3:32 PM
To: [log in to unmask]
Subject: Re: SV: image scaling?

Hi Jay,

That's great to hear - I realize you all are in the midst of
determining a solution, but any chance that there will also be an Oracle
equivalent solution as well?

>> One question: are you trying to embed the larger version of the
image, scaled to fit the report, or are you trying to embed the 192x192
pixel TMS thumbnail image?

I think it was mentioned elsewhere, but we are trying to pull images
from on-line sources, of varying sizes, and display them uniformly in a
Crystal Report, while maintaining the image's aspect ratio.

Thanks very much, and good luck!

Brenda


~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
Brenda Podemski
Business Applications Administrator
Collections Information
The J. Paul Getty Museum
www.getty.edu

v.  310-440-7087  |  f.  310-440-7752  |  e.  [log in to unmask]

>>> Jay Hoffman <[log in to unmask]> 8/22/2007 5:19 PM >>>
Dear TMS Folk,

I will take a look at this. There may be a way to do this by adding
calculated HEIGHT and WIDTH columns for an image in the database VIEW. I
did this for some html DataViews in TMS and it worked fine. It required
a SQLServer scalar-valued function, which is supported in SQLServer 2000
and 2005. It would also require that the H and W properties of the image
in the Crystal Report are settable at runtime.

One question: are you trying to embed the larger version of the image,
scaled to fit the report, or are you trying to embed the 192x192 pixel
TMS thumbnail image?

Give me a day or so and I'll file my findings here on the listserv.

Best,

Jay





From: Jeri Moxley
Sent: Wed 8/22/2007 6:38 PM
To: [log in to unmask]
Subject: Re: SV: image scaling?


Hi Suzanne,

I know your battle, as I've gone a few rounds with it myself.

Crystal 11 gives us the option of linking to jpeg files on the network
in report designs rather than being limited to the thumbnails that were
our only option in earlier versions of Crystal.

As in your case, we have images of many different sizes on our TMS
image server.

I wish I had a magic bullet for you, but Crystal doesn't seem to have
included any options for figuring aspect ratio into the equation - The
best I've come up with thus far is the following:

Set the picture to 'Can Grow' and Scaling to 80% for both H and W
Run the report and export to Word (Editable) RTF
In the Word Document, Reset the picture(s) with the icon in the picture
toolbar or in the 'Format Picture' assistant.

This is a bit of labor for the user (or their intern), but less labor
than creating their image pages from scratch.

One magical day, all of our TMS images will be one standard size and
this issue will go away. ;)


Jeri





From: The Museum System (TMS) Users
[mailto:[log in to unmask]] On Behalf Of Carl \\eoj
Sent: Wednesday, August 22, 2007 5:30 PM
To: [log in to unmask]
Subject: Re: SV: image scaling?


Have you looked at Photoshop's auto resolution feature? It's in the
image size dialog (at least in CS2) and will generate different image
sizes based on whatever line per inch standard that you may want to
set.

We use batch PS actions like this for Crystal thumbnails, but we have
one set size instead of any dynamic needs.

Suzanne Quigley <[log in to unmask]> wrote:
Thanks Albin,


I'm trying to avoid scaling all the images with photoshop in advance of
using the report (I would have to identify which images needed scaling).
 Also each fact sheet will have to incorporate not just the image but
also selection of fields (all the "boiler plate" stuff) - and I want to
be able to generate the report using an object package.


Unless you think I can scale dynamically within Crystal?


Still hopeful....


Suzanne






On Aug 22, 2007, at 11:21 AM, Albin Dahlström wrote:


well. there is a rather hidden function in photoshop, ( I really
suggest you use Photoshop )
File meny > Automate > fit image  ... and you could set the amount of
pixels you need for correct resolution.

hope that this will help
Albin MM Sweden




Från: The Museum System (TMS) Users
[mailto:[log in to unmask]] För Suzanne Quigley
Skickat: den 22 augusti 2007 17:00
Till: [log in to unmask]
Ämne: image scaling?


Hi all,


I'm working on creating a fact sheet to 'print out' as a pdf.


Using crystal 11.


Here is the rub.  My 3300+ images range between 100KB and 4MB.


Have any of you found a way to dynamically adjust the scaling of an
image depending on its file size?


Thanks for any little pointers (or big ones!)


Suzanne Quigley


"hep me, hep me, I just can't hep myself"
James Brown