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
Procedure
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.