RSS Feed
Knowledgebase : Crystal Reports
   

QUESTION: My Crystal report won't run. What's the problem? ANSWER: There are a number of possible reasons: 1) Does it work in Crystal Reports? This is always the starting point. If your answer is "I don't have Crystal Reports" or "I don't know Crystal...
Error: A Number, Currency Amount, Boolean, Date, Time, Date-Time, or String Is Expected Here Explanation: You're getting the error message "A Number, Currency Amount, Boolean, Date, Time, Date-Time, or String Is Expected Here". In general, this happens w...
INQUIRY: I want my users to be able to view Crystal Reports on their PCs without purchasing or installing Crystal Reports. SOLUTION: You want our Report Runner Viewer [http://jeff-net.com/products/crystal-reports-viewer] product.
ERROR: Microsoft ODBC Error - Logon Failed. I can't view my report. EXPLANATION: After clicking the VIEW button the report is processed and then this error appears... "Logon Failed. Details : IM002:[Microsoft][ODBC Driver Manager] data source name not fo...
Question: How do I connect Crystal Reports to QuickBooks? Answer: QuickBooks must be open because it works by communicating with the application directly. For example, if you base a report off of a Microsoft Excel spreadsheet that is password protected.....
PROBLEM: This error message "Invalid Export DLL or Export Format" exporting to Excel XLS is generally triggered by Crystal Reports templates connecting to Oracle via the Oracle ODBC driver (instead of Microsoft Oracle ODBC driver). There is an issu...
PROBLEM: When I run my Crystal Report in your Viewer, all of my dynamic parameter values do not show up. The Viewer seems to be cutting the list of values short. ANSWER: Your query is basically timing out while the Viewer fetches the values. You can...
QUESTION: Is there a way to test an OLE DB connection? I'm trying to run a report on a new machine and it is getting a database connection error. ANSWER: Yes. As long as you know the OLE DB connection information from your report (you can see this in Cr...
QUESTION: Do You Offer Free Crystal Reports Support? ANSWER: If you are looking for free Crystal Reports support, we are limited on that. While we do sometimes help, it is not our company policy. We would never be able to get any work done if we answere...
PROBLEM: My reports connect to MySQL. The driver I use is the MySQL 5 driver (myodbc5.dll). ANSWER: The Crystal runtime engine does not work with the MySQL 5 driver. SEE THIS SAP LINK REGARDING MYODBC AND THE MYSQL 5 DRIVER: http://scn.sap.com/thr...
SAP has a number of recommended tools for debugging Crystal Reports related DLL issues. The two we recommend from this list the most is Modules and Process Monitor. Follow this link to a KB article on SAP's website: http://scn.sap.com/community/c...
PROBLEM: Crystal Reports Fields Are Chopped Off Showing ##### instead of the full field value. --- ANSWER: This is not a setting in our software (and it's not a bug either). It's a Crystal Reports formatting issue. You need to widen the field us...