Configure Reports for Reporting Service

Given below are the steps to configure AVEVA Work Tasks Reports for Reporting Service. This is a five-step process which comprises of:

Prerequisites

1. AVEVA Information Server should be configured.

2. The Historian and Alarm applications should also be configured before configuring Reports.

To configure Reports

3. After configuring the AVEVA Information Server, open the Configurator from the Start > All Programs > AVEVA > Information Server

4. Select Archestra Reporting in the Configurator window.

5. Create a Data Source for Historian Sample Reports and Alarm Sample Reports.

6. Click the Configure button to configure Reports.

To verify Reports Configuration

7. After configuring the Reporting, open browser and enter the following URLs:

   1. http://[Machine Name]/ReportServer (You can use the IP address instead of the [Machine Name])

   2. http://[Machine Name]/Reports (You can use the IP address instead of [Machine Name])

   If the Reporting is configured properly, then the following paths will be available in the SQL Server Reporting Service (SSRS): /AVEVA Workflow Report/Historian

   1. By browsing the Home > AVEVA Workflow Reports > Historian folder, you can see the reports deployed in this folder. /AVEVA Workflow Report/Alarm

   2. By browsing the Home > AVEVA Workflow Reports > Alarms folder, you can see the reports deployed in this folder. (Here the report template is named as Alarm History Report.)

To test Reporting Connectivity from the Server

Perform the same steps as given in the previous section from the server. If the host name is not accessible from this server, then you can use the Internet Protocol (IP) address instead of the machine name to connect.

To create a Connection in the Reporting Service

8. Login to Enterprise Console.

9. From the Enterprise Console pull-down menu, select Settings > Reporting Services > Connections.

10. Click New to create a new connection.

11. Enter all the mandatory information.

    Note: The format of the given path must be followed as given in this document. It should start with “/” and there should be no “/” at the end of the path.

12. Click the Test Connection.

13. When the connection succeeds, click Save to save the connection.

To create a Template

14. Login to Enterprise Console.

15. From the Enterprise Console pull-down menu, select Settings > Reporting Services > Templates.

16. Click New to create a new template.

17. Click Save to store the details.