How to Set Up a Report Dashboard

- J.D. Meier, Jason Taylor, Alex Mackman, Prashant Bansode

Modify the team project portal Microsoft Office SharePoint® site in order to create a report dashboard that can provide a variety of project information in one location.

For example, a useful reporting dashboard might contain the following reports:
  • Remaining Work
  • Quality Indicators
  • Bug Rates
  • Project Velocity

You can add new reports to your SharePoint portal page by adding a Report Viewer Web Part for each report you want displayed on the page.

To modify the team project portal and create a reporting dashboard
  1. Install the Report Viewer Web part on your report server by using the stsadm.exe tool and RSWebParts.cab, included with the Microsoft Office SharePoint and Report Services installation package.
    1. STSADM.EXE can be found in the following path: C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN
    2. RSWebParts.Cab can be found in the following path: C:\ Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint
    3. Example: STSADM.EXE -o addwppack -filename "C:\ Program Files\Microsoft SQL Server\90\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall
  2. In Team Explorer, right-click your project and then click Show Project Portal.
  3. Click Modify Shared Page, point to Browse, and then click Add Web Parts.
  4. Click Virtual Server Gallery.
  5. From the Web Part List, select Report Viewer.
  6. Click Add.
  7. Enter the Report Manager name, such as http://<report server>/reports.
  8. Enter the path for the report you want to display, such as <my project>/Quality Indicators.

Additional Resources

Last edited Jul 25, 2007 at 12:20 PM by prashantbansode, version 1

Comments

No comments yet.