How to: Upload Documents to a SharePoint Library (SharePoint Integrated Mode)

New: 12 December 2006

You can upload report definitions and report models to a SharePoint library. When uploading a report server item, you must choose a library or a folder within a library. You cannot upload a report server item to a list or page.

You cannot upload an .rds file. However, you can publish .rds files from a design tool to a SharePoint library. During publication, a new .rsds file is created from the original .rds file in the solution. You can also create a new .rsds file in a SharePoint library and then set data source connection properties in the uploaded reports and models to use the new connection.


The report server must be configured for SharePoint integrated mode, and the instance of the SharePoint product or technology must have the Reporting Services Add-in that provides program files for storing and accessing report server items from a SharePoint site. For more information, see Reporting Services and SharePoint Technology Integration and Deployment Modes for Reporting Services.

To upload a document to a library, you must have the Add Items 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 and to the Members group who have the Contribute level of permission.

To add a report definition to a library

  1. Open the library or a folder within a library. If the library is not already open, click its name on the Quick Launch. If the name of your library does not appear, click View All Site Content, and then click the name of your library.

  2. On the Upload menu, click Upload document.

  3. To upload a single report or report model file, select a report definition (.rdl) or report model (.smdl) file and then click OK.

    If the report definition uses a shared data source (.rsds) file to store connection information to an external data source, you can upload the .rdl and .rsds files at the same time. To do this, click Upload Multiple Documents, specify both files, and then click OK.

If you upload a report that contains references to shared data sources, report models, or subreports, the references will be broken in the report when the files are uploaded. For more information about how to reset the references, see Deploying Reports, Models, and Shared Data Sources to a SharePoint Site and How to: Create and Manage Shared Data Sources (SharePoint Integrated Mode).

When you upload a report, it runs on demand when you open it, retrieving live data from the data source. You can configure the report to retrieve data on a schedule or use cached data. For more information, see How to: Set Processing Options (SharePoint Integrated Mode).

A report can contain parameters so that users can filter data. You can configure the parameters to use specific values or change how they appear to the user. For more information, see How to: Set Parameters on a Published Report (SharePoint Integrated Mode).

See Also


How to: Publish a Report to a SharePoint Library from Report Designer (SharePoint Integrated Mode)
How to: Publish a Shared Data Source to a SharePoint Library from Report Designer (SharePoint Integrated Mode)


Report Server How-to Topics (SharePoint Integrated Mode)
Viewing and Managing Report Server Items from a SharePoint Site
Deploying Reports, Models, and Shared Data Sources to a SharePoint Site
Managing Permissions and Security for Report Server Items on a SharePoint Site

Help and Information

Getting SQL Server 2005 Assistance