SAP Knowledge Base Article - Public

2066749 - How to create a Crystal Report using JDBC connection[Video]

Symptom

  • How to configure JDBC connection for Crystal Reports 2008
  • How to configure JDBC connection for SAP Crystal Reports 2011/2013
  • How to configure CRConfig. xml file to connect to a reporting database using JDBC connection

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011/2013

Resolution

  1. Download a jar file for the respective database (For e.g. MS SQL Server: sqljdbc4.jar, Oracle: ojdbc.jar)
  2. Extract the jar file in any directory (For e. g.: C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.1\java\lib)
  3. Open the CRConfig.xml file from the location: C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.1\java
  4. Add the path to a jar file in the <classpath> tag.
    <Classpath>C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.1\java/lib/crlovmanifest.jar;C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.1\java/lib/external/CRDBXMLExternal.jar; C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java\lib\sqljdbc4.jar; C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.1\java\lib\ojdbc6.jar;${CLASSPATH}</Classpath>
  5. Save this file and open Crystal Reports 2008 or SAP Crystal Reports 2011/2013
  6. Create a new report and choose ‘JDBC(JNDI)’ as the connection type
  7. Enter the details:
    1. Connection URL
    2. Database Classname
    3. Database User name
    4. Database Password
  8. Click on ‘Finish’
  9. All the tables would now be listed and you may go ahead and create a report
  • Path to CRConfig.xml for CR2008: C:\Program Files (x86)\Business Objects\Common\4.0\java\
  • Path to CRConfig.xml for SAP CR2011: C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/

Note: You can mention all these details in the CRConfig.xml file as well to fill it automatically.
E.g. Configure the <JDBCURL>, <JDBCClassName> and the <JDBCUserName> for Oracle as follows: 
<JDBCURL>jdbc:oracle:thin:@//VANPGREPDB02.pgdev.sap.corp:1523/ORCL</JDBCURL>

<JDBCClassName>oracle.jdbc.driver.OracleDriver</JDBCClassName>

<JDBCUserName>guest</JDBCUserName>

Media not computed.

See Also

  1. 1527666 - JDBC Connection URL's while creating Crystal Reports based on JDBC Connectivity
  2. 2066805 - Configure JDBC connection for SAP Crystal Reports for Enterprise & Information Design Tool (IDT)
  3. 1850017 - How do you set up an Oracle 11 JDBC Connection in Crystal Reports 2011 that uses Service Name?
  4. 1558463 - How to create a Crystal Report against a Teradata database using JDBC connection

Keywords

Crystal, JDBC, connection URL, CRConfig.xml, connection  , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013