Business Intelligence Development Studio (BIDS) provides the capability to deploy reports. This is very convenient since we use BIDS to design, develop, and test our reports. In this section we will walk through report deployment using BIDS.
In order to deploy our reports and data sources using BIDS, we need to specify some project settings. Right click on the project name in the Solution Explorer then select Properties from the popup menu; you will see the dialog as shown below:
The following is a description of the deployment settings:
After reviewing the deployment settings and making any necessary changes, you can deploy all data sources and reports in the project by right clicking the project in the Solution Explorer and selecting Deploy from the popup menu. You can deploy specific data sources and/or reports by selecting them in the Solution Explorer (use Ctrl + Click to select multiple), right clicking on a selected item and choosing Deploy from the popup menu.
The success or failure of your deployment will be reported in the Output window; e.g.:
Deploying to http://sql2008test/reportserver Deploying data source '/Data Sources/AdventureWorksLT'. Warning : Cannot deploy data source AdventureWorksLT to the server because it already exists and OverwriteDataSources is not specified. Deploying report '/SSRS 2008 Tutorial/ReportDesignerExample'. Deploy complete -- 0 errors, 1 warnings == Build: 1 succeeded or up-to-date, 0 failed, 0 skipped == == Deploy: 1 succeeded, 0 failed, 0 skipped ==
After a successful deployment of our sample project, you will see the following on the Report Manager home page:
To navigate to the Report Manager use the URL http://SERVERNAME/reports; if you manually configured Reporting Services using the Reporting Services Configuration Manager then specify the name you used for the Report Manager, You can click on the Data Sources or SSRS 2008 Tutorial folders to see the data source or the reports.
Now let's continue on to the next section to see how to deploy reports using the Report Manager.