While deploying SSRS (SQL Server Reporting services) in SharePoint Integration mode, the deployment Path URL’s must be absolute (this includes http://, the site collection, the path to the site,the library,). For example :
TargetServerURL – indicates which site to deploy the report. In the above example, I deployed it to a Sub-site ‘Reports’. We can even deploy it at site collection level. i.e http://dev:3660
TargetDataSourceFolder – A regular SharePoint data connection library to store & may be share the data source used by the report.
TargetReportFolder – A regular SharePoint library to save the report.
During deployment via Business Intelligence Visual Studio, it may ask for appropriate account privileges. Successful Output below : ——————————————————————————————————————————–
Deploying to http://dev:3660/Reports
Deploying data source ‘http://dev:3660/reports/ReportsDataSource/AWDataSource.rsds’.
Deploying report ‘http://dev:3660/reports/AWReports/AWVendors.rdl’.
Deploy complete — 0 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========