How Do I Manually Install the Sample Reports in Enterprise Manager?

Summary

If you skipped the sample reports installation during the AgilePoint Enterprise Manager installation, to install the reports manually, do the following.

Navigation

1. To open Microsoft SQL Server Reporting Services, click Start > All Programs > Microsoft SQL Server > Reporting Services > Report Manager.

Instructions

1. In SQL Reporting Services, create a new folder named AgilePoint.
2. Open the AgilePoint folder.
3. Click the New Data Source button.
4. Configure the New Data Source page to connect to the AgilePoint’s database.
5. Click OK.
6. Click Upload File, and then upload each of AgilePoint’s built-in reports. The report files with the extension .rdl, are located in the rdl folder where AgilePoint Enterprise Manager is installed.
7. In a text editor, open the AgilePoint Enterprise Manager web.config file.

   This file is located in the folder [AgilePoint Server installation]/Enterprise Manager

8. Add the following node for the ReportService URL:

   SQL Server 2005:

   <appSettings>
   <add key="ServerUrl" 
        value="http://localhost:8088/AgilePointServer" /> 
   <add key="ReportServiceUrl" 
        value="http://virtual/reportserver/reportservice.asmx" />
   <appSettings> 

   SQL Server 2008:

   <appSettings>
   <add key="ServerUrl" 
        value="http://localhost:8088/AgilePointServer" /> 
   <add key="ReportServiceUrl" 
        value="http://virtual/reportserver/ReportService2005.asmx" />
               <appSettings> 

The next time you open Enterprise Manager, the reports are displayed in the Report Management section.