Appendix: Configure Crystal Reports with Sophos Reporting Interface

This example shows you how to use Crystal Reports version 2008 or later to access Sophos Reporting Interface.

The Crystal Reports Wizard will automatically link columns with identical names between views that have been included in a report. However, some of the connections must be removed as similarly named columns do not necessarily have identical values for a single log event.

For example, the InsertedAt column is present in every view which denotes when each entry was added to the database. However, a single event may have different InsertedAt times for its corresponding entries in each view. If the Crystal Reports Wizard automatically links these columns, the links must be removed to prevent missing data. For information on which data sources are linked, see Which datasources are linked?.

To create the Sophos Reporting Interface connection with Crystal Reports:

  1. Open Crystal Reports and create a new connection using OLE DB (ADO) and choose Microsoft OLE DB Provider for SQL Server.
  2. Enter the connection information and complete the wizard.

Sophos Reporting Interface will now be listed in the available data sources. For information on how to generate custom reports, see the Crystal Reports documentation.

For a list of data sources that are available for Reporting Interface, see Sophos Reporting Interface data sources.

For more information and examples on using Crystal Reports to access data provided by the Sophos Reporting Interface, see knowledge base article 112873.