on 10-30-2013 7:52 AM
Hello,
Currently we are facing a problem which can be very annoying. Some Images causes our Crystal Report to crash. I'm not able to see the differences between the images that are working and those who are corrupted. The images are stored in a BLOB field.
I've also checked if the photo was corrupted using JPEGsnoop.exe. The photo used is not corrupted.
Here is the Photo which will cause the Crystal Report to Crash.
(It is only a piece of the picture but it doesn't work anyway)
The following error message is thrown by Visual Studio:
Has anyone experienced the same Problem?
Thanks in advance for your support,
Best Regards.
Message was edited by: Ludek Uher Discussion transferred to SAP Crystal Reports as this is firstly an issue in the designer. Any feedback, ideas, etc., very welcome.
I had this same issue and pinpointed it down to a specific image being read from database blob. I was able to open the jpg file (in photoshop, could use any editor I'm sure) from disk and re-save it, this took it from 88kb to 193kb and after re-uploading to the database, the report is now fine.
So, you may have a corrupt image that needs to be fixed. The 88kb was very small compared to other images, it must have been missing some information. Hope this helps someone.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
Need more info.
- Version of CR with SP level?
- Version of VS?
- Are you facing this issue from CR designer / win for viewer / web form viewer / while exporting / while printing??
Try this small test.
Design a new blank report. (no db connection)
Add this image as a picture.
and see if this report fails.
- Bhushan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank for your Answer Bhushan,
Version of CR with SP Level:
Latest with the newest SP (Support Pack 7 (v. 13.0.7.x) x32)
Version of VS?
VS 2010 & VS 2012
Are you facing this issue from CR designer / win for viewer / web form viewer / while exporting / while printing??
1. test
In designer: Connection to Oracle DB via Oracle.DataAccess.Client, then drag/drop the BLOB-field with the image from database -> crash
2. test without db connection
In designer: add the picture without database connection -> picture (which is causing the error) can be added but shows anything but not the original picture. It is also extremly Big.. Here's a screenshot:
Runtime crashes too: with CrystalDecisions.Windows.Forms.CrystalReportViewer (Version=13.0.2000.0)
and also with Version 13.0.7.x
Interesting... I tried testing it and works for me in designer as well as web viewer.
The thing is when the image is added to the report its height and width is too large.
In your snapshot also the blue thing is actually your image.
Same thing happened to me so I scaled the image height and width to 2% which made the image look smaller and everything worked fine.
I suspect that the crash is being caused by the image dimensions.
Could you test it by reducing the height and width of the image.
- Bhushan
Senior Engineer
SAP Active Global Support
Follow us on Twitter
Got Enhancement ideas? Try the SAP Idea Place
Getting started and moving ahead with Crystal Reports .NET applications.
Hi,
Yeah we also think that the crash is caused by the image dimensions. But our problem is that if this image comes from a BLOB property the designer or report will crash.
So re sizing the height and width of the image wont work well for us cause we have tons of photos and from these photos some of them will crash with the crystal report.
If i put a working image on the designer the width & the height of the picture are fine..
So the problem with the size & height only appears with some images.
To reduce the image dimentions is the only option i see here.
CR does not increse or reduce the image dims. You would need to do it manually to the images and then upload them to the DB.
With current dims, these images will never work with CR as most of the image spreads outside of the report.
- Bhushan
Our problem is that we have no access to the images itself. They come from a 3rd party application which saves the images in the Blob field. The crystal report gets the image from the blob field and crashes every few times.
I mean crystal report itself shouldnt crash although the current dimensions.
- Thomas
There is an inconsistency that I see in the description of the issue:
The following error message is thrown by Visual Studio:
Unhanded exception at0x3805d7fd in crw32.exe: 0x0000094: Integer division by zero.
If the issue is happening in Visual Studio, why is it that crw32.exe is reporting the error?
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow us on Twitter
Got Enhancement ideas? Try the SAP Idea Place
OK. So this is very, very confusing as there are a number of inconsistencies where info from VS and CR is all mixed up even though there is really no relationship between the two. E.g.; the issue is in the CR designer. Period. No need for VS to be involved in this Discussion(?).
Since as I now understand it, the issue is specific to the CR designer (crw32.exe) the Discussion should have been created in the SAP Crystal Reports design Topic Space, not SAP Crystal Reports, version for Visual Studio. You may say that this is happening in both the CR designer and runtime, but the 1st place to resolve the issue would be in the designer irrespective (just describing the process).
So, back to square one;
I will move this Discussion to the SAP Crystal Reports design Topic Space
And two questions:
What is the exact version of CR you are using? Please go to Help | About and quote the exact version you see there.
You should be able to export the BLOB field to a file format, such as jpg / png / etc.? As a test, if you insert the exported file into the report, do you get the same issue?
- Ludek
OK. I'll move this discussion to the SAP Crystal Reports Space. One last piece of info I can add here:
KBA - 1893544 - How to reduce the file size of Crystal Reports when using images
Let's see if the report design gurus can all anything else.
- Ludek
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.