Configure Default Report on IPE

This section describes the procedure to configure default reports.

Note: You must follow this procedure to configure any other reports for AIM.

Defining a View for Reports in the Viewsscript.sql File

To define a view for reports, you must run the Viewsscript.sql file in the reporting database, after running the SSIS package for the first time.

Uploading the Default Reports

To make the default reports (rdl files) available in AIM, you must connect to a data source and upload these files into the SSRS directory.

To upload the default reports:

1. Browse to the following path:

   http://{myserver}:portno/reports

   Note: Replace {myserver} with your computer name.

2. Select New Data Source.

   The New Data Source window opens.

   

3. In the Name box, type SSRSDB.

4. In the Connection String box, copy the following:

   Data Source=Nameoftheserverinstance;Initial Catalog=Nameofthedatabase

   Note: Replace Nameoftheserverinstance with your server name, and Nameofthedatabase with the name of the database you have created.

5. For Connect using, select Credentials stored securely in the report server.

6. Enter the User name and Password, and then select OK.

7. In the Report Manager Home page, select New Folder to create a folder for reports.

   

8. Open the Folder, and then select Upload File.

9. Select Browse, and then select the rdl file provided for IPE located in the following path: {install path}\Report\Report Example\

10. Select OK.

11. In the drop-down list of the Report uploaded, select Manage.

    

12. In the left pane, select Data Sources.

    

13. In the right pane, select A shared data source, and then select Browse.

14. Select the data source created in step 4.

15. Repeat the steps 5 and 6 for the remaining rdl reports.

16. To open the default IPE reports, double-click those reports.

Importing EIWM to Interact with Dashboard

You can view SSRS reports in Dashboard. Each report can be created as an AIM Report or its child classes pointing to the SSRS URL of the specific report.

The following example provides the XML scripts for creating the report:

17. Create a class under the AIM Report using the following EIWM:

    <?xml version="1.0" encoding="utf-8" standalone="yes"?>

    <?vnet xslt="NULL"?>

    <vl:VNETList xmlns:vl="http://www.aveva.com/VNET/List"

    xmlns="http://www.aveva.com/VNET/eiwm">

    <Class>

    <ClassID>SSRS REPORT</ClassID>

    <ParentClassID>AVEVA NET REPORT</ParentClassID>

    <ClassName>SSRS Report</ClassName>

    <PluralName>SSRS Reports</PluralName>

    </Class>

    </vl:VNETList>

18. Import the Class for AVEVA NET Report.

19. Import the Report using the Import Controller.

Modifying Default Report XML

To modify default report XML:

20. Open the default report XML file.

21. Edit the following script:

    <Value>http://{server}/ReportServer/Pages/ReportViewer.aspx?%

    2fAVEVA+NET+Sample+SSRS+Reports%

    2fEquipment+Mismatch&amp;rs:Command=Render&amp;rc:LinkTarg

    et=_self</Value>

22. Replace {server} with the actual server name.

23. Replace ReportServer with the Virtual Directory Name, configured in Web Service URL page of the Reporting Services Configuration Manager.

24. Replace AVEVA+NET+Sample+SSRS+Reports with the actual folder name.

    Note: If a folder is not created for the reports on the Report Manager, then remove AVEVA+NET+Sample+SSRS+Reports from the URL above.