You must create a new ClearQuest database connection in
Crystal Reports to design a data-pull report.
Procedure
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.