Deploying SSRS 2008 Reports in sharepoint integrated mode.

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 ==========

Posted in Sharepoint 2010, SQL Server Reporting Services

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: