Publishing Reporting Services reports to SharePoint in SharePoint Integration mode

Reporting Services reports can be published to SharePoint using 2 modes, Native and SharePoint Integration Mode, here we shall see on how to publish a Reporting Services Report to a SharePoint Library in the SharePoint Integration mode.

1. Before publishing reporting services reports to SharePoint using the integrated mode, make sure that the reporting services is configures in “SharePoint Integration mode”, refer the post , to see on how to configure this.
2. Open the SQL Server Business Intelligence Development Studio, create a new report / open an existing report
3. Open Project -> Properties -> Deployment Section
4. Under TargetDataSourceFolder, enter the full URL of the SharePoint library where the datasource of the report needs to be saved.
5. Under TargetReportFolder, enter the full URL of the SharePoint library where the report needs to be saved.
6. Under TargetServerURL, enter the URL of the site / sub-site which will host the report.
7. Once done, deploy the report and the same will get added to the SharePoint Library.
8. Once the report is published to the Library, we can refer to the report from other pages / web parts and display the same.