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.
Preferred method of creating a new ClearQuest data source
Attention: This method functions only with Crystal Reports version 11
release 2.
- 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.