How to: Upload Documents to a SharePoint Library (Reporting Services in SharePoint Integrated Mode)
You can upload report definitions and report models to a SharePoint library. When uploading a report server item, you must select a library or a folder within a library. You cannot upload a report server item to a list or page.
You cannot upload a data source (.rds) file. However, you can publish .rds files from a design tool, such as Report Designer, 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 Overview of Reporting Services and SharePoint Technology Integration and Planning a Deployment Mode.
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 or report model to a library
Open the library or a folder within a library.
Click Upload document, and then depending on whether you want to upload a single or multiple documents, click Upload Document or Upload Multiple Documents.
Browse and select a report definition (.rdl) or report model (.smdl) file.
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 the .rsds file at the same time. To do this, click Upload Multiple Documents and specify both files.
Optionally, type a version comment.
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 Models and Shared Data Sources to a SharePoint Site and How to: Create and Manage Shared Data Sources (Reporting Services in 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 (Reporting Services in 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 (Reporting Services in SharePoint Integrated Mode).