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
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
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