The CRConfig.xml file contains configuration
information that is used by Crystal Reports. You must update this file to
enable the ClearQuest Reporting Driver.
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. In Crystal Reports
version 11 release 2,
CRConfig.xml is located in the
following directory:
C:\Program Files\Business Objects\Common\3.5\java
About this task
To enable the ClearQuest Reporting Driver:
- 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 .jar file that is required by
the ClearQuest Reporting Driver. A separate entry is required for each .jar
file.
drive:\CQReportsDriver\stpwvcm.jar;drive:\CQReportsDriver\stpcq.jar;drive:\CQReportsDriver\stpcmmn.jar;drive:\CQReportsDriver\cqjdbc.jar;
- Because ClearQuest requires Java 5.0, which is included as part
of the product installation, you must replace the following line:
<JavaDir>C:\Program Files\Business Objects\j2sdk1.4.2_08\bin</JavaDir>
with this line:
<JavaDir>drive:\%RATIONAL_COMMON%\Java5.0\jre\bin</JavaDir>
- (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:dataSet/database</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>
Results
After you save the modifications to
CRConfig.xml,
the ClearQuest Reporting Driver is accessible as a Crystal Reports data source.