Learn more about SQL Server tools

 
 

Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

BIDS


     

Overview
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.

Explanation
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.






More SQL Server Solutions




Post a comment or let the author know this tip helped you.

All comments are reviewed, so stay on subject or we may delete your comment.

*Name    *Email    Notify for updates 

Note: your email address is not published. Required fields are marked with an asterisk (*)


Get free SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools