Article ID	1968
Article Title	HOWTO: Avoid Problems with Crystal Reports 9 running from VDF
Article URL	http://www.dataaccess.com/KBasePublic/KBPrint.asp?ArticleID=1968
KBase Category	Crystal Reports
Date Created	02/04/2004
Last Edit Date	03/08/2010

Article Text
PROBLEM:
I cannot run a report built with Crystal 9 from the Deployment machine. From the development machine it works. Any suggestions?

SOLUTION:
To avoid problems when deploying Crystal reports, be aware of and check for:

- Make sure that you do not have different versions of the Crystal Reports or Crystal Connectivity Kit files in different directories. Example: APIDLL.DLL, CRPE32.DLL and the DF_COLLATE.CFG sometimes are placed in the Windows\System32 directory and those may be found before the ones with the right version. Note that you may also experience other problems, like error 4405 (see links below), for having file version mismatch.

- Make sure you have only one copy of each Crystal or CK files -- Example: Having crdb_p2bdfapi.dll in multiple locations will generate errors (DataFlex will not be displayed in the "New Connection" tree, error "The database DLL 'crdb_p2bdfapi.dll' could not be loaded." or even "Failed to Create the Crystal Query Engine" may be displayed when trying to run a report)

- Make sure you are deploying all the needed DLLs -- remember that special formulas require different DLLs -- and DataFlex files, like TAGs, for example.

- On the development machine, check which DLLs are being loaded. You can verify that by using Modules (a utility to view loaded DLLs) or from the Crystal Reports Designer -- the option Help | About Crystal Reports | More Info lists all the DLLs used by the report and the path where they are being loaded from.

- If Crystal Reports is installed on the deployment machine, add Crystal 9 directory (default: C:\Program Files\Common Files\Crystal Decisions\2.0\bin) to the PATH environment variable. That way Crystal directory will be searched when files are needed.

- Visual DataFlex has Crystal Reports files installed to its Bin directory. Those should not be used for deployment -- they are installed with the development license so the sample applications that demonstrate the use of Crystal Reports in VDF can be run -- and they may be from a version of Crystal Reports other than the one your reports were built for

- Consult the Connectivity Kit User's Guide (Start | Programs | DataFlex Connectivity kit for Crystal Reports 9 | User's Guide) and the Crystal help file Runtime.chm available with the Developer Edition of Crystal Reports (default location: C:\Program Files\Crystal Decisions\Crystal Reports 9\Developer Files\Help) and Crystal's Knowledge Base for more information about deploying your reports

- Make sure all the DLLs that need to be registered are indeed registered -- like CRQE.DLL (for Crystal Query Engine) and CTRSLV.DLL and EXPORTMODELLER.DLL (for exporting to PDF/RTF format)


Important!
If running a report from a previous version of Crystal Reports, make sure you have followed the instructions to convert your report before you attempt to run it in Crystal 9.


Contributed By:
Marcia Booth
Company: Data Access Worldwide
Web Site: http://www.dataaccess.com

Links Related to this Article
Crystal - Runtime File Requirements for the Report Designer Component version 9
DAW Knowledge Base article 1226: INFO: Runtime DLL Files for Special Formulas
DAW Knowledge Base article 1671: INFO: Export Format DLLs needed for deployment
DAW Knowledge Base article 1695: HOWTO: Check DLLs necessary for Deployment
DAW Knowledge Base article 1814: HOWTO: Register ActiveX Controls
DAW Knowledge Base article 1824: INFO: When the Deployment of .TAG Files is Required
DAW Knowledge Base article 1839: ERROR: Error number out of range
DAW Knowledge Base article 1883: INFO: Information on Crystal 9 and VDF Applications
DAW Knowledge Base article 1969: ERROR: Failed to Create the Crystal Query Engine in Crystal Reports 9
DAW Knowledge Base article 1971: INFO: Crystal Reports and Registered DLLs
DAW Knowledge Base article 1979: HOWTO: Convert to Crystal Reports 9
DAW Knowledge Base article 2238: INFO: Get Details on Running Processes with Process Explorer Utility

Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2024 Data Access Corporation. All rights reserved.

The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply.