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 UNIX 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.