Print Page | Close Window

Fatal Error: Crystal reports has stopped working

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16453
Printed Date: 21 Apr 2025 at 12:11pm


Topic: Fatal Error: Crystal reports has stopped working
Posted By: nwohio
Subject: Fatal Error: Crystal reports has stopped working
Date Posted: 16 May 2012 at 10:22am

“Crystal reports has stopped working.  A problem caused the program to stop working correctly.  Windows will close the program and notify you if a solution is available.”  Using CR2011.  Occurs with certain tables from MySQL database with Connector ODBC 5.1.  Some tables will select in Report Creation Wizard whereas others will generate the error and close the program.  Have received same error from 2 independent databases.  Solutions and suggestions welcome as I cannot proceed without a repair.  Thanks in advance.


Replies:
Posted By: nwohio
Date Posted: 17 May 2012 at 4:29am
I have since learned the tables not selectable exceed 12 characters in tablename.  In other words, any tablename <= 12 characters will be selected for field explorer.  Apparently names not truncated create the error.  Is there a fix so I may use my existing databases to create reports and evaluate CR 2011?

Posted By: kevlray
Date Posted: 17 May 2012 at 5:17am
I have never run into this.  I assume it is an ODBC issue, because I am using an MS-SQL database with table and field names longer than 12 characters.

Posted By: nwohio
Date Posted: 17 May 2012 at 5:22am
I am using a 30 day trial version of CR2011 and perhaps restrictions have been implemented by SAP.  Any thoughts?

Posted By: nwohio
Date Posted: 17 May 2012 at 5:23am
Also, what is the correct ODBC driver for this application?  As stated I am using the 5.1.11.

Posted By: exedriver
Date Posted: 04 Jun 2012 at 2:23am
I am facing the same problem - mySQL ODBC Version 5.1.11, CR2011 (full version, no trial). Some databases are working - some not. I installed the latest CR2011 Patch 17 but no change. Do you have a solution for that problem nwohio?

Posted By: nwohio
Date Posted: 04 Jun 2012 at 3:20am
I can only offer what I have already posted:  the 12 character limit to table names.  That 5.1 driver works for me.  Test the table name scenario by selecting only <12 char tables and then add one with >12 to see if it crashes.  Good luck.

Posted By: exedriver
Date Posted: 04 Jun 2012 at 3:57am
In my case it even crashes when I select tables with <12 chars. Looks like I need to open a ticket at SAP 


Print Page | Close Window