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 or later.
- Select Blank Report. The
Database Expert window opens.
- Click . The
JDBC connection wizard opens. Note that the JDBC Connection option
is 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 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, see
technical note 1515079 .
- 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.