1214829 - Configuring Crystal Reports 9 to use JavaBean classes as datasources

SAP Knowledge Base Article - Public

1214829 - Configuring Crystal Reports 9 to use JavaBean classes as datasources

Symptom

  • While attempting to create a new report based on Java Data, a new data connection is created by going to Create New Connection > More Data Sources > Java Data from within the 'Database Expert' dialog box.
  • However, instead of receiving a list of existing Java Bean classes to choose from there are "no items found".
  • How can you create a report using your existing Java Bean classes as a data source?

Resolution

====================

WARNING:

The following resolution involves editing the registry. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall the Windows operating system. Use Registry Editor at your own risk.

For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.

====================

  1.  Close Crystal Reports Designer. 
  2. On the 'Start' menu, click 'Start' and then 'Run'
  3. Type "regedit.exe" in the 'Run' dialog box and click 'OK' to open the Registry Editor. 
  4. Navigate to the 'HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\9.0\Crystal Reports subkey.
  5. Right-click the 'Crystal Reports' subkey and choose "New" > "Key". Name this new subkey "Database". 
  6. Right-click the 'Database' key and click 'New' > 'String Value' and name this entry JavaBeansClassPath"
  7. Set the value of the 'JavaBeansClassPath' entry to the directory (or directories) that contains the compiled Java Beans class files. If you are using more than one directory, separate them with a semi-colon. For example: C:\JavaBean\Datatype\;C:\JavaBean\Linking\
  8. Navigate to the  HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\9.0\Crystal Reports' subkey
  9. Right-click the 'Crystal Reports' subkey and click 'New' > 'String Value'. Name this entry "JREPath"
  10. Set the value of the 'JREPath' entry to the location of Jvm.dll. For example: C:\j2sdk1.4.0\jre\bin\client\jvm.dll
  11. Ensure that the folders containing the JRE are added to the operating systems environment variable
  12. Close the Registry Editor and then restart Crystal Reports. Your Java Bean classes are now be listed as Java Data in the Data Expert

 Additional Information

---------------------

If you are using Crystal Enterprise:

" The Crystal Reports registry keys described in this knowledge base are created even if you have not installed Crystal Reports.

" The registry key changes described in this knowledge base must be made to the Page, Job, and Report Application Server servers.

" The Java Bean class file must be local to all these processing servers, otherwise the error message "Unknown Query Engine Error" will appear.

 

 

 

 

 

Keywords

CR9 JAVABEAN JAVADATA JAVA CLASS BEAN DATA SOURCE CE Crystal Reports Database Expert More Data Sources | Java Data Java Bean Classes as report data sources , c2011506 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 9.0