Report Server Deployment Options

IRC uses Microsoft SQL Server Reporting Services (MSSSRS) to publish and deliver reports. Before beginning installation, ensure that SRS is working properly and that the instance to be used for Reporting Services are configured. The database instance needs to be specified during IRC activation. The following are determined:

MSSSRS supports a wide range of common data sources, such as OLEDB (Object Linking and Embedding Database) and ODBC (Open Database Connectivity), as well as multiple output formats such as familiar Web Browsers and Microsoft Office System applications. Using Microsoft Visual Studio .NET and the Microsoft .NET Framework, developers can leverage the capabilities of their existing information systems and connect to custom data sources, produce additional output formats, and deliver to a variety of devices.

The reporting server may be deployed as described in the following scenarios:

  • Database server and report server on different machines: In this scenario, the report server must be manually added as a linked server on the database server. Entries for report schedules is not on the calendar. The linked server must be configured before you install and activate IRC. The account used for linking must be the same account used for DB creation, that is, the sysadmin account.
  • Application Server, Report Server, and the DB server on different machines
  • Application Server, Report Server, and the DB server on the same machine
    Note: For both the distributed scenario and the single setup scenario(SSL and Non-SSL), the report localization file Approva.SSRS.ResourcesEx.dll must be copied from [Install Path]\MSSRSS\RDLLocalization located on the IRC Application server to [Microsoft SQL Server [Install Path]\Reporting Services\ReportServer\bin located on the Report server before activating IRC services. Also copy one of these language specific folders as per your requirement.
    • he-IL
    • de-DE
    • es-ES
    • fr-CA
    • fr-FR
    • pt-BR
    Note: Ensure that the copied .dll files are not blocked. To confirm:
    1. Right click the .dll file to view the Properties.
    2. Ensure that the Unblock check box is selected in the Security section of the General tab. The Unblock check box is displayed only if the files are in the blocked state.
  • For Certification Manager, copy the file Infor.ReportHelper.dll from [Install Path]\MSSRSS\RDLLocalization located on the Certification Manager Application server to [Microsoft SQL Server [Install Path]\Reporting Services\ReportServer\bin located on the Report server.
    Note: Ensure that the copied .dll files are not blocked. To confirm:
    1. Right click the .dll file to view the Properties.
    2. Ensure that the Unblock check box is selected in the Security section of the General tab. The Unblock check box is displayed only if the files are in the blocked state.
  • DB server and Report Server on the same machine.