You must create a new Rational® ClearQuest® data source when
using Crystal Reports to design a data-pull report.
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.
- Still in the Database Expert, expand the database name. For example, SAMPL.
- Expand the Stored Procedure item to display
the list of ClearQuest queries
that you can access.
- 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.
- 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.
- Still in the Database Expert, double-click Add Command under
the new connection.
- Type a valid ClearQuest query
name in the Enter SQL query in the box below text
box. For example, Public Queries/All Defects.
- Click OK to close the Database Expert.
The command now appears in the Field Explorer in
the Database Fields folder.
- Proceed to design the report layout.