SQL Server Reporting Services

AgilePoint provides special integration features for SQL Server Reporting Services and comes with a set of pre-configured sample reports built using SQL Server Reporting Services. AgilePoint Enterprise Manager provides the user interface for building, viewing, and exporting reports. Although SQL Server Reporting Services is most often used, Crystal Reports, Microsoft Excel, and other reporting technologies can also be used to build your own reports as needed. The AgilePoint database schema is fully documented and can be used to facilitate custom reports. AgilePoint server also exposes a wide range of Web services that can be used to query and retrieve process-related data from AgilePoint Server. This data can be used to generate reports in a variety of ways using a variety of tools. You can also leverage AgilePoint APIs that will return process and run time statistic data in the form of XML. The XML data can then be used in a custom reporting tool that takes XML as an input.

The AgilePoint SQL Server Reporting Services Integration is installed as part of the AgilePoint Enterprise Manager installation. During the installation of Enterprise Manager, the installer will prompt you to install the AgilePoint SQL Server Reporting Services Integration component, which includes a set of pre-configured sample reports. To install this component requires that you have a working instance of Microsoft SQL Server Reporting Services installed. Refer to the AgilePoint Installation Guide for more information on installing the AgilePoint SQL Reporting Services Integration.