on 04-05-2012 11:43 AM
On some occasions when a user previews a crystal report document they get a message about an integer division by zero. If user then attempts to perform same operation a second time, it completes without an error message being reported.
The following is logged in the application log:
... caused a EXCEPTION_INT_DIVIDE_BY_ZERO in module craxdrt9.dll at 001B:3C37D525, DllUnregisterServer()+2573224 byte(s), EAX=00000960 EBX=000000F0 ECX=00000000 EDX=00000000...
C:\Program Files\Crystal Decisions\Report Designer Component\craxdrt9.dll, version 9.2.3.1022
Users connect and run the application via dumb terminals on a Citrix environment.
Citrix presentation server for windows, advanced edition, version 4.5 (build 3276), service pack 2006.10
Operating system: Microsoft Windows server 2003 R2, version 5.2 build 3790 Service pack 2
CR 9 has been out of support for a number of years now. All I can suggest is to enable the following options on the report:
If you have access to the code do the same verify - after DB logon. Sorry, I don't remember the exact API for craxdrt.
- Ludek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your input
Have advised report writer on the above re: query of value
Also searched the SAP forums: integer division by zero
Found three articles of interest as document contains a number of images. I know that dynamically inserting an image with a resolution from the database that is too high can cause preview of report to fail. The following suggest an exception re: division by zero may also occur from images used...will look into this further...
=====================================================
http://scn.sap.com/thread/895628
Integer Division By Zero Exception
re: Microsoft GDI+ ICO File Divide By Zero Bug
=====================================================
http://scn.sap.com/thread/1345572
Dynamic Images in Crystal Reports
re: Application popup: Crystal Reports - [Inventory Graphics Report.rpt]: crw32.exe - Application Error : The exception Integer division by zero.
=====================================================
http://scn.sap.com/thread/1040630
Error during reporting execution and viewing
Initially reference to C:\Temp folder
Following report refresh, error similar to reported
...exception integer division by zero...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Al
Building on what Don said, do this in your division formulas:
if isnull({field A}) or {field A}=0 then 0 else {field B} / {field A}
Debi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi AI,
That error can happen if the report uses a numeric field and the value is null.
Check your report and the fields in the reports as well as the database. Sometimes some DB's insert a null value even if they are not allowed, typically an error in the DB or the third party program that inserts data allows nulls even thought the table doesn't allow them.
In the Report and the formula causing the problem you can add a check for null's:
IF ISNULL({Field}) THEN 0 Else {field}
Or something like that.
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
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.