The reports in Team System are located in two places: the SQL Server reporting portal and within Team Explorer. You can access the reports in the SQL Server reporting portal by expanding your Team Project within Team Explorer, right-clicking on the Reports node, and selecting Show Report Site. You can alternatively access your Team System project reports by typing in the following in your Web browser: http://localhost/Reports/.
There are several ways you can share a report using Windows SharePoint Services. You can use the SQL Reporting Services Web Parts or the page viewer, which allows redirection based on a URL. To make any modifications to the team portal, you need Microsoft FrontPage. You can also use the Web Part Manager to drag the appropriate parts and specify the report URL. Here are the steps to add a report to the team portal using the Page Viewer Web Part:
Click Modify Shared Page⇨Design This Page.
Click Modify Shared Page⇨Add Web Part. You are then presented with the following options: Browse, Search and Import.
Select Browse and then select the Page Viewer Web Part.
You can then drag the part to the left portion of the screen.
Click the down-arrow at the corner of the Web part and select Modify Shared Web Part.
In the Link section on the right, enter /Reports/">http://<servername>/Reports/.
You can run the reports by double-clicking on them in Team Explorer. Reports can also be executed by clicking on the links on the SQL Server Reporting Services Web site. As easily, you can delete a report on Team Explorer by selecting Delete. On the reporting site, your reports can be deleted by clicking on the Show Detail option, checking off the report you want to delete and clicking on the Delete option.
Note that deleting a report in this way will remove it from your Team Project permanently, but will not affect the process template you used to instantiate the project.
Unfortunately, you cannot really export reports from Team Explorer. All you can do is print from the interface by clicking on the printer icon. On the reporting site, you can export in a variety of formats including the following:
XML file with report data
Comma delimited (CSV)
Acrobat (PDF) file
The Excel and PDF formats are very handy for creating redistributable versions of the reports.