How deploying data source and report on SharePoint 2010 from a SSRS 2012 project inside SQL Server Data Tools

Question

Hi,

I'm trying to deploy a SSRS 2012 data sources and reports from SQL Server Data tools. I've installed SSRS 2012 in integrated mode for my SharePoint farm, following this article:

http://msdn.microsoft.com/en-us/library/gg492276.aspx

I've also started the SSRS service in the Central Admin and I've created the related service application to enable a reporting site. I'v created some libraries adding the SSRS content types.

As the targer server url I've specified the http://reporting_site_name Url, but I cannot perform the deploy from the SSDT.

So, I need to know which changes there are respect to deploy with SSRS 2008 R2. I underline that I'm using SSRS 2012 and SSDT.

Any helps to me, please? Many thanks

Answer 1

First you have to create an site collection where you will host your reports, and some libraries for reports, shared dataset, shared datesources.

Ex:

Have both OverwriteDatasets and OverwriteDataSources set to true.

TargetDatasetFolder: http://reporting_site_name/sites/portal/DataSets
TargetDatSourceFolder: http://reporting_site_name/sites/portal/DataSources
TargetReportFolder: http://reporting_site_name/sites/portal/Reports
TargetReportPatFolder: http://reporting_site_name/sites/portal/ReportParts
TargetServerURL: http://reporting_site_name/sites/portal

Make sure not to add "/" at the end of the URL.

Answer 2

Hi irusul, thanks for your reply.

Reporting_site_name isn't the name of the SharePoint machine but the name of the web app and so the site collection where publishing my report.

I can access successfully to this report server url: http://reporting_site_name/_vti_bin/reportserver in the IE browser of SQL Server 2012 machine with the SQL Server Data tools.

I've specified as TargetServerURL the URL http://reporting_site_name/ (with the final slash) and, f.e., I've indicated http://reporting_site_name/reports_library_name as the URL for the document library where publishing the reports and then I've deployed successfully!

Thanks and bye