Creating a new connection

You must create a new ClearQuest database connection in Crystal Reports to design a data-pull report.
About this task
To create a new ClearQuest database connection in Crystal Reports:
  1. Start Crystal Reports version 11.
  2. Select Blank Report. The Database Expert window opens.
  3. Click Create New Connection > JDBC (JNDI). The JDBC connection wizard opens. Note that the JDBC Connection option selected.
  4. 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
  5. 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
  6. Click Next.
  7. Specify your user name and password and click Finish. A new connection appears under the JDBC (JNI) folder.

Feedback