Learn more about SQL Server tools

mssqltips logo

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Deploy Reports


In the prior sections we used Business Intelligence Development Studio (BIDS) to create some sample reports.  BIDS has a Preview capability which allowed us to render our report in the development environment.  When we have completed a report we need to deploy it so that other users can run it. 

In this section we will show how to deploy reports using the following methods:

  • Business Intelligence Development Studio (BIDS)
  • Report Manager

In SQL Server 2005 Reporting Services you could also use SQL Server Management Studio to deploy reports.  This functionality has been removed in SQL Server 2008.

You can also deploy reports to a SharePoint document library when you configure Reporting Services in SharePoint Integration mode.  We are not covering SharePoint Integration in this tutorial.

Now let's continue on to the next section to see how to deploy reports from BIDS.

More SQL Server Solutions

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

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 

SQL tips:

*Enter Code refresh code     

Learn more about SQL Server tools