I am using Crystal XI, reporting against a SQL Server stored procedure that provides paths to .jpg files on a server. I've had very good results with dynamically displaying the images, but I'm having difficulties controlling the image size on the report.
The problem is that the images are of varying sizes (and unfortunately the images are controlled by our clients, not by us).
The OLE objects with dynamic links can point to any of the images on the server, so I need one size adjustment that will apply to all images. I have found that if a .jpg file has dimensions of 640 x 480, I can set the picture scaling in the Crystal Format Editor to get the correct size. However, if the incoming image is 1536 x 1008, the same scaling adjustment produces an image that is far too big. I have tried using Format Editor to adjust the size instead of the scaling (e.g., 1" x 3/4") , but since Crystal automatically fills in a scaling value, the results are essentially the same.
I've done some research on tek-tips, and found some posts from over a year ago (thread149-1265595 and thread149-1254389) indicating that this is a known issue, the only solution at that time was to make sure the image sizes were all uniform on the server.
Does anyone know if there have been any Crystal XI updates or changes since July/August 2006 that might address this situation? Or, failing that, has anyone found a good workaround - some way to force dynamic images of varying sizes to display in one uniform size on the report? Management at my company is reluctant to ask the customers to fix their file sizes - I need to let them know if there is any way around.
Thank you!
The problem is that the images are of varying sizes (and unfortunately the images are controlled by our clients, not by us).
The OLE objects with dynamic links can point to any of the images on the server, so I need one size adjustment that will apply to all images. I have found that if a .jpg file has dimensions of 640 x 480, I can set the picture scaling in the Crystal Format Editor to get the correct size. However, if the incoming image is 1536 x 1008, the same scaling adjustment produces an image that is far too big. I have tried using Format Editor to adjust the size instead of the scaling (e.g., 1" x 3/4") , but since Crystal automatically fills in a scaling value, the results are essentially the same.
I've done some research on tek-tips, and found some posts from over a year ago (thread149-1265595 and thread149-1254389) indicating that this is a known issue, the only solution at that time was to make sure the image sizes were all uniform on the server.
Does anyone know if there have been any Crystal XI updates or changes since July/August 2006 that might address this situation? Or, failing that, has anyone found a good workaround - some way to force dynamic images of varying sizes to display in one uniform size on the report? Management at my company is reluctant to ask the customers to fix their file sizes - I need to let them know if there is any way around.
Thank you!