Creating a new data source

You must create a new Rational® ClearQuest® data source when using Crystal Reports to design a data-pull report.
Note: 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.

There are two methods by which you can create a new ClearQuest data source when using Crystal Reports to create data-pull reports. The preferred method functions only with Crystal Reports version 11 release 2 or higher.

Preferred method of creating a new ClearQuest data source

Attention: This method functions only with Crystal Reports version 11 release 2 or later.
  1. Still in the Database Expert, expand the database name. For example, SAMPL.
  2. Expand the Stored Procedure item to display the list of ClearQuest queries that you can access.
  3. Select a query name from the Stored Procedure list and click the right-arrow button ( > ) to add the query to the report. If the query requires parameters, you will be prompted for initial parameter values.
  4. Proceed to design the report layout.

Alternate method of creating a new ClearQuest data source

Attention: Dynamic query parameters are not processed when using this alternate method.
  1. Still in the Database Expert, double-click Add Command under the new connection.
  2. Type a valid ClearQuest query name in the Enter SQL query in the box below text box. For example, Public Queries/All Defects.
  3. Click OK to close the Database Expert. The command now appears in the Field Explorer in the Database Fields folder.
  4. Proceed to design the report layout.

Feedback