Sample Reports

AgilePoint comes with a number of pre-configured sample reports. Once the AgilePoint SQL Server Reporting Services Integration and the sample reports are installed, you can access them from the Enterprise Manager Reports page. The sample reports include:

The AgilePoint sample reports are deployed to SQL Server Reporting Services during the installation. Open Microsoft SQL Server > Reporting Services > Report Manager and click the AgilePoint link. The sample reports are stored here, additional reports can be added as desired.

The AgilePoint sample reports are accessed from the Enterprise Manager Main Page by clicking the Configuration link in the Report Management section. The sample reports show on the Reports page. The Reports page allows you to add, edit, or delete a report.

To add a report to Enterprise Manager:

  1. Open SQL Server Reporting Services and click the AgilePoint link.
  2. Click Upload File.
  3. Browse and select the report file for which you want to add. The report file is added.
  4. Open Enterprise Manager and click the Configuration link. The Report Management window appears.
  5. Click Add. The Report Browser window appears. The Report Browser window displays all the reports that reside on the Report Server. From this window you can select a report from the Report Server to add in Enterprise Manager.
  6. Select the newly added report and in the Label field, type a name for the report.

    Checking the Show Shortcut check box will display a shortcut link to the report on the AgilePoint Enterprise Manager Main Page. A maximum of three (3) report shortcuts can be displayed on the Enterprise Manager Main Page at a time.

  7. Click OK. The report is added. To edit a report in Enterprise Manager:
  8. From the Report Management page, click the option button next to the report for which you would like to edit and click Edit. The Report Browser window appears.
  9. Change the Label name and click OK. The report is now renamed to the new name.

To delete a report in Enterprise Manager:

  1. From the Report Management page, click the option button next to the report for which you would like to delete and click Delete. Click OK in the confirmation window. The report is deleted from the list.

To create a report:

  1. From the Report Management page, click the Average Process Time by Automatic Activities link. The View Report page appears. The View Report page requires some configuration parameters.
  2. In the Process Definition drop-down list, select ExpenseReport_InfoPath as the Process Template you want this report to run against.
  3. In the Time Format field, select Hour and click View Report to generate the report.

To export a report:

You can export the report into various formats such as HTML, CSV, XML.

  1. Click the Select a format drop-down list and select CSV (comma delimited).
  2. Click Export.