Actually, Jay, I am trying to use the preferred image (whatever size it is) to fit the report (not the thumbnail). I love the fact sheet. I'd be happy if it could be 'printed' as a pdf (from the current selection and/or as a single work). But the very idea of a 3/4 page image makes my heart skip a beat. Suzanne On Aug 22, 2007, at 8:19 PM, Jay Hoffman wrote: > 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 >> >> > >