7.7 Configuring Crystal Reports Server to Work with the Sentinel Control Center

The following procedures are required for Crystal Reports Server to work with Sentinel Control Center:

7.7.1 Configuring inetmgr

  1. Copy the web.config file from c:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Web Content to c:\Inetpub\wwwroot

  2. Launch the Internet Service Manager by clicking Start > Run.

  3. Specify inetmgr, then click OK.

  4. Expand (local computer) > Web Sites > Default Web Site > businessobjects.

  5. Right-click businessobjects, then click properties.

  6. In the Virtual Directory tab, click Configuration.

  7. Ensure that you have the following mappings. If not, add them. If you are adding a mapping, do not click the businessobjects or crystalreportsviewer11 nodes.

    Extension

    Executable

    		 
    .csp

    C:\Windows\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll

    .cwr

    C:\Windows\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll

    .cri

    C:\Windows\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll

    .wis

    ...\BusinessObjects Enterprise 11.5

  8. Click OK to close the window.

  9. Restart IIS:

    1. Expand (local computer) > Web Sites > Default Web Site.

    2. Right-click Default Web Site, then click Stop.

    3. Right-click Default Web Site again, then click Start.

NOTE:After Crystal Reports Server is installed, you must download and install the Sentinel Core Solution Pack, which includes both report templates and the necessary files to patch Crystal Reports. The installation instructions are provided in the Solution Pack documentation.on the Sentinel Content Web site.

7.7.2 Patching Crystal Reports

To view Crystal Reports from the Analysis tab of the Sentinel Control Center and to publish the reports from Solution Manager, several Crystal Enterprise files need to be updated to make them compatible with the browser.

The following table lists the Crystal Reports Enterprise files and describes the purpose of each file. The Crystal Reports Enterprise files can be extracted from the crystal_patch.zip file, which is available as an attachment in the Sentinel Core Solution Pack under the Global Setup control.

Table 7-1 Crystal Enterprise Files

File name

Description

calendar.js

calendar.html

Displays a pop-up calendar when you select a date as a parameter to a report.

grouptree.html

Displays a Loading message when the reports are loading.

exportframe.html

Displays a window that allows you to export a report for saving or for printing.

exportIce.html

File used by Sentinel when exporting a report for saving or for printing.

GetInfoStore.asp

File used to query the Crystal server.

GetReports.asp

File used by the Sentinel Control Center to establish a connection with Crystal Server and display the report list.

GetReportURL.asp

File used to support hyperlinks between reports.

helper_js.asp

A call file used by GetInfoStore.asp.

publish_report.aspx

Used to publish reports directly from a Solution Pack to the Crystal server when a control is installed.This file is also included in the SP2 patch distribution.

delete_report.aspx

Used to remove reports directly from the Crystal server when a control is uninstalled.This file is also included in the SP2 patch distribution.

To patch Crystal Reports:

NOTE:Ensure that you have read the Sentinel Reports Release Notes before performing this task, because there can be updated files, scripts, and additional steps that need to completed.

  1. Log in to Crystal Reports Server machine as a user who is a member of BusinessObjects NT Users group.

  2. Extract the Crystal Enterprise files from the crystal_patch.zip file to a local directory.

  3. In the patch directory of Sentinel Reports Distribution, copy the following files:

    • Copy all *.html and *.js files to the viewer file location. The default location is:

      C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Web Content\Enterprise115\viewer\en

    • Copy all *.asp and *.js files to:

      C:\inetpub\wwwroot

      Your Web folder might be on a different drive or location.

  4. In the Crystal installation directory, create a subdirectory for Sentinel. In a default installation, the path is:

    C:\Program Files\BusinessObjects Enterprise 11.5\Web Content\Enterprise115\WebTools\Sentinel

  5. Place the publish_report.aspx and delete_report.aspx files in the Sentinel directory.

    The publish_report.aspx and delete_report.aspx files are available in the reports_patch\IIS directory of the Sentinel 6 SP2 distribution or in the Sentinel Reports distribution.

  6. Open the web.config file from the Crystal install directory.

  7. Add two new entries to the <assemblies> section of the web.config file for Enterprise.PluginManager and Enterprise.Desktop.Report. The following example shows a sample <assemblies> section:

    <assemblies>
<add assembly="CrystalDecisions.CrystalReports.Engine, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=123abcd1234a1234" />
<add assembly="CrystalDecisions.ReportSource, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=123abcd1234a1234" />
<add assembly="CrystalDecisions.Shared, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=123abcd1234a1234" />
<add assembly="CrystalDecisions.Web, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=123abcd1234a1234" />
<add assembly="CrystalDecisions.Enterprise, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=123abcd1234a1234" />
<add assembly="CrystalDecisions.Enterprise.Framework, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=123abcd1234a1234" />
<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=123abcd1234a1234" />
<add assembly="CrystalDecisions.Enterprise.Shared, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=123abcd1234a1234" />
<add assembly="CrystalDecisions.Enterprise.PluginManager, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=123abcd1234a1234" />
<add assembly="CrystalDecisions.Enterprise.Desktop.Report, Version=11.5.3300.0, Culture=neutral, PublicKeyToken=123abcd1234a1234" />
</assemblies>

    IMPORTANT:The new entries should use the same Version, Culture, and PublicKeyToken values as the other entries in your file.

  8. Restart the Web server and the Crystal Reports server.