Enabling the ClearQuest Reporting Driver

Update the Crystal Reports configuration file with path information for the ClearQuest Reporting Driver files.

Before you begin

The following environment variable is used in path names in this topic:
%RATIONAL_COMMON%
Directory where Rational common files are installed
Before performing the steps in this topic, create a backup copy of the crconfig.xml file. For Crystal Reports XI R2, the default location for the file is:
C:\Program Files\Business Objects\Common\3.5\java
For Crystal Reports version 11 release 2, cronfig.xml is located in the following directory:
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\

Procedure

To enable the ClearQuest Reporting Driver:

  1. Using a text editor, open the crconfig.xml file. In the DataDriverCommon element, update the ClassPath element to include the fully qualified path for each file that is required by the ClearQuest Reporting Driver. A separate entry is required for each file.
    C:\CQReportDriver-dir\stpwvcm.jar;C:\CQReportDriver-dir\stpcmmn.jar;drive:\CQReportDriver-dir\cqjdbc.jar;drive:\CQReportDriver-dir\cqjni.jar;drive:\CQReportDriver-dir\stpcq.jar;
    Important: Append the reporting driver files to the end of the Classpath specification after the original items. Do not include the file stpclientws.jar in the Crystal Reports ClassPath. Including this file in the path can cause errors in Crystal Reports.
  2. If you are using Crystal Reports 11 release 2, change the Java runtime setting to this value:
    <JavaDir>C:\Program Files\IBM\RationalSDLC\common\Java5.0\jre\bin<JavaDir>
    This step is not required for Crystal Reports 2011.
  3. (Optional) In the JDBC element, customize the settings to describe the ClearQuest JDBC driver. This step is useful if you want the ClearQuest Reporting Driver settings to be saved as the default JDBC driver.
    <JDBC>
    		<CacheRowSetSize>100</CacheRowSetSize>
    		<JDBCURL>jdbc:cq:DBset/LogicalDBname</JDBCURL>
    		<JDBCClassName>com.ibm.rational.clearquest.jdbc.CQDriver</JDBCClassName>
    		<JDBCUserName>user</JDBCUserName>
    		<JNDIURL><JDBCIURL>
    		<JNDIConnectionFactory></JNDIConnectionFactory>
    		<JNDIInitContext></JNDIInitContext>
     		<JNDIUserName>weblogic<JNDIUserName>
     		<GenericJDBCDriver>
    			<Option>Yes</Option>
     			<DatabaseStructure>catalogs,tables</DatabaseStructure>
    			<StoredProcType>Standard</StoredProcType>
    			<LogonStyle>Standard</LogonStyle>
    		</GenericJDBCDriver>
    </JDBC>
    Note: If using ClearQuest Web server connection by default, replace the JDBCURL parameter setting with this definition:
    <JDBCURL>jdbc:cq:DBset/LogicalDBname@http://localhost:12080/TeamWeb/services/Team</JDBCURL>

Results

After you save the modifications to crconfig.xml, the ClearQuest Reporting Driver is accessible as a Crystal Reports data source.

Feedback