How to: Add the Report Viewer Web Part to a Web Page (SharePoint Integrated Mode)
New: 12 December 2006
You can use the Report Viewer Web Part to view reports that run on a SQL Server 2005 Reporting Services Service Pack 2 report server that is configured to run in SharePoint integrated mode. You can use the Web Part to display report definition (.rdl) files that you created in Report Builder or Report Designer and uploaded to a library.
You can add the Report Viewer Web Part to a Web page if you want to embed a report on that page.
Although they have identical names, the Report Viewer Web Part that is installed through the Reporting Services Add-in differs from the Report Viewer Web Part that is included in the RSWebParts.cab file. The instructions in this topic are specifically for the Report Viewer Web Part that is installed through the Reporting Services Add-in. For more information about how the Web Parts compare, see Comparing Levels of Integration Across Versions of Reporting Services and SharePoint Technologies.
To add a Web Part to a Web page, you must have the Add and Customize Pages permission at the site level. If you are using default security settings, this permission is granted to members of the Owners group who have the Full Control level of permission.
To embed a report in a Web page
Open or create the Web Part page or dashboard.
On Site Actions, click Edit Page.
Click Add a Web Part.
In All Web Parts, in the Miscellaneous section, select SQL Server Reporting Services Report Viewer.
Click Add. The Web Part is added at the top of the zone. You can drag it to a different location in the zone.
Open the tool pane.
Select a report from any library in the current site collection by clicking the browse (...) button. You can also type the report URL. To determine the URL for any report, right-click the report and select Properties. Do not click the down arrow next to the report; the report URL is not indicated in the View Properties page of the item. If you copy and paste the URL from the Properties dialog box, replace the %20 URL encoding with a space (for example, "Company%20Sales" should be "Company Sales").
Each Report Viewer Web Part contains a single report. The URL must be the fully-qualified path to a report that is on the current SharePoint site, or on a site within the same Web application or farm. The URL must resolve to a document library or to a folder within a document library that contains the report. The report URL must include the .rdl file name extension. If the report depends on a model or shared data source files, you do not need to specify those files in the URL. The report contains references to the files it needs.
While the tool pane is open, you can set properties to modify the default appearance and layout.
Click Apply at the bottom of the tool pane, and then click OK to close the pane.
Report Server How-to Topics (SharePoint Integrated Mode)
Using the Report Viewer Web Part on a SharePoint Site
Customizing the Report Viewer Web Part
Features Supported by Reporting Services in SharePoint Integration Mode
Viewing and Managing Report Server Items from a SharePoint Site
Managing Permissions and Security for Report Server Items on a SharePoint Site