O'Reilly logo

Microsoft SQL Server 2012 Bible by Aaron Nelson, Jose Chinchilla, Patrick LeBlanc, Jorge Segarra, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Deploying Reporting Services Reports

This section explores the options and strategies to deploy the reports to the report server. Deploying directly from the development environment, SQL Server Data Tools (SSDT) is the simplest method for the developer, but it may not always be possible or wanted depending on configuration and security constraints.

Deploying Reports Using SSDT

Deploying reports using SSDT requires some basic configuration of the Reporting Services project. When configured, reports (and other resources such as data sources and images) can be deployed individually or the entire project can be deployed.

To configure the deployment properties for a Reporting Services project, open the project's property page by right-clicking the Reporting Services project and selecting Properties. Figure 56.3 shows the property page for a Reporting Services project, and Table 56.1 summarizes the deployment properties available for a Reporting Services project. You can deploy to either the native mode Report Manager or a SharePoint integrated mode server using SSDT.

Figure 56.3 Use the settings on the property page of a Reporting Services project to configure the deployment options.

56.3

Table 56.1 Reporting Services Project Deployment Properties

Property Description
OverwriteDataSets Set this to true if you want to overwrite data sets on the report server with data sets in the report ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required