Creating a new connection

You must create a new ClearQuest® database connection in Crystal Reports to design a data-pull report.

Before you begin

Before you can design Crystal data-pull reports using ClearQuest data sources, the Crystal Reports environment must be configured to use the ClearQuest Reporting driver. See Configuring the Crystal Reports Designer for ClearQuest reporting.

Procedure

To create a new ClearQuest database connection in Crystal Reports:

  1. Start Crystal Reports version 11 or later.
  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 is 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 ClearQuest Web server URL is optional:
    jdbc:cq:dataSet/database[@CQWebServer-URL]
    The following example shows a JDBC connection URL that uses a ClearQuest Web server URL:
    jdbc:cq:7.1.0/SAMPL@http://myserver:12080/TeamWeb/services/Team
    Note: Reports that define connections to locally defined ClearQuest profiles cannot be hosted on 64-bit WebSphere® Application servers. If your target application server is WebSphere 64-bit edition, use connections that access ClearQuest using a Change Management Server. This is done by appending the change management server URL to the connection string as shown in Step 4. For details, seetechnical note 1515079 .
  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