Crystal Training Faqs/Forums

Print Engine API/SQL Databases FAQ
< back

1. From which databases does Crystal Reports support stored procedures?
   
   Crystal Reports supports stored procedures from most of the common databases. In some cases stored procedure support depends on whether the report is connecting to the database through Crystal ’s direct database drivers or through an ODBC connection. Before you attempt to create your report, select File | Options and select the SQL tab. This tab will include a frame titled ‘Allow Reporting On’. Ensure that the option for Stored Procedures is checked on. When this option is checked on, Crystal Reports will allow reporting on the result sets from stored procedures if you are using a database that support stored procedures. You may also check on ‘Prompt on every table’ in the same frame of the SQL tab. With this option checked on, Crystal Reports will display the ‘Allow Reporting On’ dialog box before it displays the ‘Choose SQL Table’ dialog box.
   
   The document Stored Procedure Support describes what is required to report off stored procedures from MS SQL Server, Sybase, Oracle, Informix, and DB2 databases.
2. Configuration error: PDCTBTRV.DLL cannot be loaded.
   
   This error usually occurs when creating a new report off a Btrieve database or when verifying the database (Database | Verify Database) in an existing report. This error is usually a result of Crystal Reports not able to find or load PDCTBTRV.DLL and/or WBTRVDEF.DLL. PDCTBTRV.DLL is by default installed in the Windows\Crystal directory and WBTRVDEF.DLL in the Windows\System. PDCTBTRV.DLL needs to find WBTRVDEF.DLL in order to execute the report. If this file is not in the Windows\System directory then the directory in which it resides must be in the Windows search path. WBTRVDEF.DLL is part of the Btrieve engine. It is crucial that the Btrieve engine (local or server) is properly configured before you attempt to create reports. If the Btrieve engine hasn’t been configured then Crystal Reports provides the user the ability to install the local engine. To install the local engine, run setup.exe from the BTI directory (or BTI32 for 32 bit Crystal Reports), located in your Crystal Reports directory.
   
   For 32 bit users, P2CTBTRV.DLL is the 32 bit equivalent of PDCTBTRV.DLL and WBTRVD32.DLL is the 32 bit equivalent of WBTRVDEF.DLL.
3. Making the report read off a different datasource within the Crystal Reports designer.
   
   It is possible to make your report use a different datasource. If you want to make the change within the Crystal Reports designer please refer to the document on changing datasources. Please refer to the section labeled " Making the change in the Crystal Reports designer ".
4. Error Message: "Setup Routines \ Specified Driver could not be loaded"
   
   If you are receiving any one of the following errors, please read through the document ODBC Driver Errors . Ensure that all of the steps listed in the document have been taken in order to ensure database connectivity within Crystal Reports.

         ODBC error: [Microsoft][ODBC DLL] Specified driver could not be loaded.
   
   The Setup Routines for the "Driver Name" ODBC driver could not be loaded. You may be low on memory and need to quit a few applications.
   
   The Setup Routines for the "Driver Name" ODBC driver could not be loaded due to system error code XXXX.

5. Requirements for Oracle Stored Procedures Access
   
   It is possible to report off Oracle Stored Procedures ONLY if you connect to the database via Crystal ’s direct drivers. The 16-bit version of Crystal Reports can access Oracle stored procedures using PDSORA7.DLL and the 32-bit version of Crystal Reports can access stored procedures using P2SORA7.DLL. Please refer to the knowledge base article "Requirements for Oracle Stored Procedures" for a description of how the stored procedures must be created in order for Crystal Reports to access them.
6. How to use API calls to execute a simple report from a Visual Basic application.
   
   Often times developers familiar with the Crystal Custom Control (OCX) need a certain functionality which is not supported in the OCX. In these cases, it is recommended that they use a different Crystal Reports development tool, i.e. API Calls. The API Begin document will demonstrate the basic API calls required to execute a report that connects to a PC type database.
7. How do I change the printer orientation at runtime using API calls?
   
   The printer orientation of a report can be changed at runtime by using the PESelectPrinter function call. You must set the ‘Mode’ parameter of PESelectPrinter in order to have the ability to change the printer orientation. The Mode parameter specifies a pointer to the Windows API structure DEVMODE. This Windows API structure contains information about a printer driver’s initialization and environment data. If you are using Visual Basic and you want to modify the DEVMODE structure you must include CRWRAP.BAS (version 6.0) in your project, and use crPESelectPrinter instead of PESelectPrinter.
8. Making the report read off a different datasource at runtime using API Calls.
   
   It is possible to point your report to a different database at runtime. If you want to make the change at runtime using API calls please refer to the document on changing datasources. Please refer to the section labeled "Making the change from a front end application using API Calls ".
9. Accessing Subreports from a Visual Basic application using API Calls.
   
   Since Crystal Reports 5.0 developers have been able to access subreport objects contained in reports using API calls. Refer to the document Subreports and API for an example of how to access subreports using API calls. This document will demonstrate how to retrieve the subreport name, get the handle and open each subreport. Once this is achieved then the subreport can be treated the same as a regular report.
10. Crystal Reports Print Engine Error Codes.
    
    Please refer to the list of error codes and their descriptions that get generated by the Crystal Reports Print Engine when necessary.

 FAQs/Forums

 BI-Training.com

 Contact Us