Deploy SSRS Reports in SharePoint Integration Mode

This blog addresses deployment of SSRS Reports and Report Models to a SharePoint 3.0 Site. This information can be gleaned from the following MS TechNet article, Deploying Models and Shared Data Sources to a SharePoint Site. The intent is to (hopefully) make the necessary deployment settings for SharePoint Integration Mode more explicit and straightforward.

Assumptions:

• Report Server has been configured for SharePoint Integration Mode.
• SharePoint Report Server Integration Feature is activated.
• Appropriate Content Types (Report Builder, Report Builder Report, Report Data Source) have been added to a Document Library within a site.

For further information on these configuration topics, see Deploying SSRS with SharePoint Integration.

Assume the following server/site/library/folder names:

• Server Name = MyServer
• SP Site = SiteABCReports
• Doc Library = SSRS Reports
• Data Sources Folder (optional) = Data Sources
• Report Models Folder (optional) = Models
• Reports Folder (optional) = Reports

Deploy Report Designer Reports

From within a SQL Server Business Intelligence Studio (BIDS) Report Server Project, go to the project’s Property Page (right-click project in Solution Explorer and select Properties).
Apply the following deployment settings:

• Overwrite ExistingDataSources = True
• TargetDataSourceFolder = http://MyServer/SSRS%20Reports/[Data%20Sources]
• TargetReportFolder = http://MyServer/SSRS%20Reports/[Reports]
• TargetServerURL =http://MyServer

Where [‘xxx’] denotes optional.

Things to note:

• A TargetReportFolder must be specified. The folder can be the document library or a folder within the document library.
• The TargetDataSourceFolder is optional. If one is not specified, the Data Source will be deployed to the TargetReportFolder.
• For both target properties, if the folder within the document library does not already exist, it will be created upon deployment.
• Relative paths are not valid.
• The replacement of the space character with %20

Deploy Report Models

From within a SQL Server Business Intelligence Studio (BIDS) Report Model Project, go to the project’s Property Page (right-click project in Solution Explorer and select Properties).
Apply the following deployment settings:

• OverwriteExistingDataSources = True
• TargetDataSourceFolder = http://MyServer/SSRS%20Reports/[Data%20Sources]
• TargetModelFolder = http://MyServer/SSRS%20Reports/[Models]
• TargetServerURL = http://MyServer

Note: The TargetModelFolder and TargetDataSourceFolder properties must be set to the document library or folders within the document library.

Throughout this blog, where a folder within a document library is specified, this folder is optional. Folders at this level merely serve to organize the different types of report support files.