You must create a new ClearQuest database connection in Crystal
Reports to design a data-pull report.
To create a new ClearQuest database connection in Crystal Reports:
- Start Crystal Reports version 11.
- Select Blank Report. The
Database Expert window opens.
- Click . The JDBC
connection wizard opens. Note that the JDBC Connection option
selected.
- When you enabled the ClearQuest
Reporting Driver, if you did not perform the optional step to modify
the <JDBC> element in the CRConfig.xml file,
then you must customize the connection URL to point to your database. The
format for the ClearQuest JDBC URL is shown next. Note that the CM Server
URL is optional:
jdbc:cq:dataSet/database[@CMServer-URL]
The following example shows a JDBC connection URL that uses a CM Server
URL:jdbc:cq:7.1.0/SAMPL@http://myserver:12080/TeamWeb/services/Team
- When you enabled the ClearQuest
Reporting Driver, if you did not save the <JDBCClassName> value,
then you must type the class name in the Database Classname field
as shown here:
com.ibm.rational.clearquest.jdbc.CQDriver
- Click Next.
- Specify your user name and password and click Finish. A new connection appears under the JDBC (JNI) folder.