SharePoint Library Delivery in Reporting Services
A report server that is configured for SharePoint integration includes a delivery extension that you can use to send a report to a SharePoint library.
To use the SharePoint delivery extension, you must create a subscription from an application page on a SharePoint site, and then select SharePoint document library as the delivery type. You cannot use the SharePoint delivery extension for subscriptions that you create in SQL Server Management Studio or Report Manager.
The delivery extension does not support the delivery of reports to a SharePoint site if the report server is running in native mode. If you attempt to call the delivery extension programmatically for a native mode report server, the server will return the rsDeliveryExtensionNotFound error and log the rsOperationNotSupportedSharePointMode error in the report server log files. For more information about server modes, see Planning a Deployment Mode.
Requirements for delivering rendered reports to a library include the following:
The report server must be configured for SharePoint integration mode.
The report server must have the SharePoint delivery extension installed and configured.
The report must be a report definition (.rdl) file. You cannot deliver other report server content types, such as models or resources, through a subscription. You cannot subscribe to ad hoc reports that use models as a data source.
The report must use stored credentials. This is a prerequisite for creating any subscription on a report, regardless of the delivery type.
The subscription must be an individual subscription. Data-driven subscriptions are not supported in SharePoint integrated mode.
The destination must be a SharePoint library. When choosing a target library, you must choose one that is on the same SharePoint site. You cannot deliver a report to a library on another server or another site within the same site collection.
Properties and metadata are not part of report delivery. When the report is delivered for the first time, it inherits the security settings of the folder or list that contains it. If you subsequently modify security settings or set report properties, those settings are retained. The subscription just refreshes the report that is stored at the specified location.
Go to the SharePoint site from which you access the report.
Select the report, click the down arrow next to the report, and select Manage Subscriptions.
Click Create, Edit, or Delete.
A Status message on the Manage Subscriptions list displays current information about the subscription, including whether it succeeded and the date and time the subscription last ran.