Link to home
Start Free TrialLog in
Avatar of RichfordsIt
RichfordsIt

asked on

Pictures In Crystal

Okay, so I have a place holder image in my crystal report. In the format graphic and graphics location of that place holder, I have a field that holds  a URL to another image.

The only thing is when that url is in the field, The image comes out like 8x bigger than the place holder.

How do I make it the same size.
Avatar of Mike McCracken
Mike McCracken

The images have to be sized before being in the report.  You can do some sizing in the report but all images will get the same changes.

Are all the images the same size?
If so make sure your place holder image is the same size then size it through the Crystal controls and I believe the other images will work.

mlmcc
Avatar of RichfordsIt

ASKER

All the images are sadly different sizes, This is because they are sent through a programme called iforms, and different technicians take them so there is no guarantee.
I'll research some more but unless it has changed in the newer versions that is the way  it is.

What version of Crystal are you using?

mlmcc
Crystal Report XI, I'll research a bit more aswell.

It would be good to learn something new about crystal.
CR XI is the version they added the ability to change the image through the formula.  I am pretty sure you can't resize based on the image.

mlmcc
Ah okay, I'll consult with my colleague, because I am sure he found a way with our BER reports.
One of the 3rd-party Crystal Reports User Function Libraries (see list at: http://kenhamady.com/productlinks/default.html#ufl ) provides a function that lets you resize an image from a URL or a file source to specified dimensions (with an option to maintain proportions).
Here is an example of how the UFL function is used for the "Graphics Location" expression: uflImageResize("http://www.ssa.org/images/home_header_left.gif", "c:\temp\Glider_Resized.png", 180, 222, True, "")
The first argument is the image source.
The 2nd argument is the local resized image created. You can convert on the fly between image formats by specifying a different file extension.
The 3rd & 4th arguments are width & height in points (72 points = 1 inch).
The next argument controls whether the image would maintain its proportion while not exceeding the specified dimensions.
ASKER CERTIFIED SOLUTION
Avatar of RichfordsIt
RichfordsIt

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I unticked the tick box for can grow in the format graphic