Configuring Crystal Reports, version for Eclipse

To use the Rational® ClearQuest® Report Server for Crystal Reports for ClearQuest® reporting, install and configure a supported version of the Crystal Reports, version for Eclipse on the WebSphere® Application Server.

Before you begin

If you have already installed the Java™ Reporting Component runtime, remove the existing version before performing these configuration steps. See Removing the Crystal Reports runtime.

About this task

These instructions include references to this variable:

%CLEARQUEST_HOME%\cqweb\cqwebprofile: On Windows™, this variable represents the default path for the WebSphere® profile directory where Rational® ClearQuest® web applications are deployed. CLEARQUEST_HOME is the directory where ClearQuest® is installed.
$CQ_HOME/cqweb/cqwebprofile/: On Linux™, this variable represents the default path for the WebSphere® profile directory where Rational® ClearQuest® web applications are deployed. CQ_HOME is the directory where ClearQuest® is installed.

Note: In these instructions, the installation directory for the JRC runtime is based on Rational® ClearQuest® being installed in a new WebSphere® profile at this default location:

cd $CLEARQUEST_HOME/cqweb/cqwebprofile/installedApps/dfltCell/RationalClearQuestWebReport.ear/CQWebReport.war

If Rational® ClearQuest® was installed into an existing WebSphere® Application profile, this path might be different, and the path in the instructions must be updated before copying the JRC files. One other common location to check is this directory:

cd /opt/ibm/clearquest/cqweb/cqwebprofile/installedApps/dfltCell/RationalClearQuestWebReport.ear/CQWebReport.war

Procedure

Download the Crystal Reports, version for Eclipse archive file that meets your Rational® ClearQuest® reporting requirements.
Copy the Crystal Reports, version for Eclipse to the web application.
On Windows™
Run the batch file to copy the JRC to the web application.
If you are using Crystal Reports, Version for Eclipse, run the configureJRC.bat. For JRC version 12.2.x, run configureJRC12.bat
1. From a command prompt, go to the directory where the Rational® ClearQuest® batch files were installed:
  cd %CLEARQUEST_HOME%\cqweb\cqwebprofile\installedApps\dfltCell\RationalClearQuestWebReport.ear\CQWebReportModule.war
2. Copy the runtime archive file into this directory.
3. Run one of the following commands depending on which version of the runtime you are deploying.
  configureJRC CR4ERL32_0-80004572.zip configureJRC12 JRC_runtime_file.zip
On Linux
If you are using Crystal Reports, version for Eclipse, run the configureJRC.sh. For JRC, version 12.2.x, run configureJRC12.sh.
1. Open a Linux™ console window and go o the directory where the Rational® ClearQuest® shell scripts were installed.
  cd $CQ_HOME/cqweb/cqwebprofile/installedApps/dfltCell/RationalClearQuestWebReport.ear/CQWebReport.war
2. Copy the Crystal Reports, version for Eclipse runtime archive file into this directory.
3. Set the permission for the version of the script you want to run:
  chmod u+x ./configureJRC.sh chmod u+x ./configureJRC12.sh
4. Run the command for the JRC version you are copying:
  ./configureJRC.sh CR4ERL32_0-80004572.zip ./configureJRC12.sh JRC_runtime_file.zip
Note: The Crystal Reports .zip file name and version may vary depending on SAP release.
Stop and restart IBM® WebSphere® Application Server to activate the changes.
Note: The directory in these instructions might be different if Rational® ClearQuest® was installed into an existing WebSphere® profile.
On Windows™:
1. Click Start > Control Panel > Administrative Tools > Services.
2. In the Services pane, right-click IBM® WebSphere® Application Server v8.5 or 9.0 - %CLEARQUEST_HOME%\cqweb\cqwebprofile.
3. Click Stop.
4. After the service stops, right-click on the server name and click Start to restart the server.
On Linux™:
1. From a Linux™ console window, go to the bin directory of the WebSphere® profile where Rational® ClearQuest® server components are installed.
  Note: The directory in these instructions might be different if Rational® ClearQuest® was installed into an existing WebSphere® profile.
  +++ cd $CQ_HOME/cqweb/cqwebprofile/bin
2. Run these commands to stop and start the default profile:
  ./stopServer.sh server1 ./startServer.sh server1
To verify that the Rational® ClearQuest® Report Server for Crystal Reports is configured properly, open a browser window and go to this URL: http://localhost:<port>/cqwebreport/CRInvoker
Where <port> is the port defined in the profile to deploy the application. The default Rational® ClearQuest® profile uses port 12080. The default WebSphere® Application Server profile uses port 9080.
If the server is configured properly, this message is displayed.
```
The report document has expired.
```
Additional configuration steps are required in these situations:
- A database field name is changed in the Rational® ClearQuest® schema.
- Rational® ClearQuest® display field names do not match database field names.
- Rational® ClearQuest® display field names exceed 30 characters.