Displaying Team System reports in the Team Portal
You can display Team System reports in the Team Portal using the default Page Viewer web part, which redirects to the URL
_layouts/tfsredirect.aspx?IsReport=1&ReportName=name
But there's a better way.
I recommend installing the SQL Server 2005 Reporting Services Web Parts. They're already on your server, but they're not set up. To set them up, run this command on your Team Foundation Server web tier:
C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN\
STSADM.EXE -o addwppack -filename
"C:\Program Files\Microsoft SQL Server\90\Tools\
Reporting Services\SharePoint\RSWebParts.cab"
Once you do this, you'll have two new Web Parts specifically designed for reporting, so you no longer need to rely on the generic Page Viewer. Note that the new controls are in the "Virtual Server Gallery":
Here's the Report Explorer web part in action
And here's the Report Viewer web part in action:
The report gadgets work better. They offer much more control over the report output. For one thing, if you set any parameters to the report in design mode, those parameters are saved. You can also turn off the toolbar so the report comes up pre-configured to whatever parameters you last set.
Note that you will need to bits of information in the properties for each control:
- Report Manager URL: http://teamsystem/Reports
- Start Path (explorer): /teamproject
- Start Path (viewer): /teamproject/reportname
Remember, friends don't let friends use the generic Page Viewer web part to view Team System reports!