yes, yes, yes, I'll have what Jeri is having!!  3/4 page with  
'caption' (what I would call boiler plate).

Jay - if you solve this riddle you are a saint and will go to heaven.

Suzanne



On Aug 22, 2007, at 8:24 PM, Jeri Moxley wrote:

> Hi Jay,
>
> The report I've been working on is a full-page image for Registrars  
> to use for condition reports, so we're using the full size jpeg files.
>
> I'd also like to create a report with a 3/4 page (approx.) image,  
> with label copy below it, for Curatorial staff who are putting  
> together image pages for their exhibitions.
>
> Thanks!
>
> Jeri
>
> From: The Museum System (TMS) Users [mailto:TMSUSERS@SI- 
> LISTSERV.SI.EDU] On Behalf Of Jay Hoffman
> Sent: Wednesday, August 22, 2007 8:19 PM
> To: [log in to unmask]
> Subject: Re: SV: image scaling?
>
> 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:TMSUSERS@SI- 
> LISTSERV.SI.EDU] 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:TMSUSERS@SI- 
>> LISTSERV.SI.EDU] 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
>>
>>
>
>