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:
- 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.
- 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.
- (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.