Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

Deploying and Administering SSRS

After creating reports for your end users, you are ready to deploy them to the Report Server.

Then your end users can view them in the Report Manager. The Report Manager is the loca-

tion your end users can go to in order to view their reports and set up subscriptions to have the

reports scheduled and delivered to them via email or the Windows file system.

Now you will need to deploy the reports. To do this you need to set the proper folders and

server on the Report Server project properties in BIDS. To set these, click the project link at

the top of BIDS and select the last option, Properties. This window is shown in Figure 28-1.

FIGURE 281

The properties you need to set in this window are listed under Deployment:

OverwriteDatasets:



If this property is set to true, the datasets in the project will be

deployed even if a given dataset already exists in the Report Server.

28

889633c28.indd 247 8/16/10 9:12:21 PM

248



LESSON 28 Deploying anD aDministering ssrs

OverwriteDataSources:



If this property is set to true, the data sources in the project will

be deployed even if a given data source already exists in the Report Server, replacing the

existing data source.

TargetDatasetFolder:



This is the name of the folder in which the datasets will be saved on ...