Friday, November 2, 2012

SSRS - Different ways of Deploying Reports

1.   Background

This article describes how to deploy the reports in different ways using SQL Server Reporting Services: Following are the different ways in which we can deploy the report:
  • Report Deployment from BIDS/Report Builder/SQL Server Data Tools.
  • Report Deployment from Report Manager.
  • RS command prompt utility
  • Backup and Restore of Report Server DB.

2.   Prerequisite

  • Reporting services should be configured in the instance.
  • SQL Server Reporting services should run.
  • Reports that need to deploy should run in the BIDS/ Report Builder/ SQL Data Tools without any issue.
  • Report Server and Report Manager URL should work.

3.   Steps to deploy the report:

a)    Report Deployment from BIDS/Report Builder/SQL Server Data Tools.

Below is the sample report named “EmployeeReport” with shared dataset and data source in BIDS. Report is working fine in BIDS. Below is the screenshot.
                I.        Right click on the project top node named “MyProjectSolution” and click on Build:

Build succeeded :

              II.        Right click on project top node named “MyProjectSolution” and select Property:

             III.        It will open the property window. Here we can set the deployment property for the report. Below are the property need to set for report deployment:
  • TargetDataSourceFolder         :           MyDataSource
  • TargetDatasetFolder                :           MyDataSets
  • TargetReportFolder                  :           MyReports
  • TargetReportPartFolder           :           MyReportPartFolder
  • TargetServerURL                      :           http://vishal-pc/reportserver
  • TargetServerVersion                :           SQL Server 2008 R2 or later
  • OverwriteDatasources             :           Based on your requirement
  • OverwriteDatasets                    :           Based on your requirement

Below is the screenshot showing deployment configuration settings:
Click ok to save the settings.

            IV.        Go to the report server URL to check whether Report server URL is working fine or not: http://vishal-pc/reportserver :

Report server url is working fine and there are no reports available.

             V.        Now go to Reporting solution, right click on project top node and click on deploy:

So Report has been deployed successfully. See the below screenshot from BIDS:

            VI.        To verify whether report deployed successfully or not. Go to Report server URL and run the report.

Here we are able to see the deployed objects:

           VII.        Go to My Reports folder and run the report:

Report is working fine. See the below screenshot:
Note : Deployment steps for Report builder/ SQL Data Tools is same as BIDS.

b) Report Deployment from Report Manager
Report deployment from Report Manager means uploading the Reports, Data Sources and Datasets from file system to Report Server DB by using Report Manager.

                I.        Below are the report items that we will deploy  by using Report Manager:
              II.        Go to Report Manager URL e.g  (http://servername/reports) and check whether these report items are there or not:

There are no report items in the Report Manager.

             III.        Create the folder for Datasource, Dataset and Report in report manager. For creating folder click on new folder:
Provide the folder name and description and click ok.

It will create the folder for Datasource. Create the folder for Dataset and Report also.

            IV.        Below is the screenshot of all the folders created in Report Manager:

             V.        Go to DataSource folder and click on New Data Source:

It will open the page for creating data souce. Provide the Data source name, connection string and credential type and click Ok.:

Now we can see data source has been created.

            VI.        Now go to DataSet folder and click on Upload File:
 Provide the path of Dataset and clcik Ok:

It will create the dataset. Below is the screenshot:

           VII.        Repeat the VI for Report folder and upload the rdl file. Below screehsot showing datasource, dataset and report both uploaded successfully.
         VIII.        Now go to the report folder, click on drop button on report and click on Manage to see whether report is mapped to correct dataset or not:

It will open the property for the report. Click on “Shared Dataset” and select the correct dataset for report.

Click Ok. It will map the “Reseller” dataset to the report.

            IX.        Go to DataSets folder and select the Dataset “Reseller” and click on Drop button and select Manage:

             X.        It will open the Dataset property. Click on DataSource and select the dataset for the dataset:

Click Ok. It will map the dataset to datasource.

            XI.        Go to the report folder and run the report.

Report is working successfully.

c)  Backup and Restore of Report Server DB:  It is one of the simplest way of deploying all the reports from one environment to another environment. This way is useful when we are deploying report first time in any environment in which there are no existing reports.

                I.        Below is source environment where all the reports are available(http://vishal-pc/reports)::
Below is the report that is available in this environment :

              II.        Below is the target environment where no report items are available(http://sqlcircuit/reports):

             III.        Take the Backup of ReportServer DB from the source system:
            IV.        So we have taken the backup of source Report server DB in G:\ReportDeployment folder. Now restore it to the target SQL server instance.
Note: SQL Server Reporting Services should configured properly in the target instance

             V.        Now go to Report Manager URL and check whether all the report items came or not. (http://sqlcircuit/reports)

            VI.        Run the report and see whether you are able to run the report or not:

Report is working fine.
d) Report Deployment using RS utility
RS.exe is a command prompt utility that Processes script you provide in an input file (.rss). We use this utility to automate report server deployment and administration tasks.

RSS file: The .rss file contain the code to read the report item  file from the local system, upload the file to report server and set data source. We can write .rss file using Visual

Below is the syntax for RS.exe

rs –i c:\ReportDepolyment\RSDeploy.rss -s http://localhost/reportserver

4.   Conclusion

By using the above steps, we can deploy the SSRS reports
----------------------------------------------------End of Document---------------------------------------------------


  1. Thanks lot, it is very nice article. But i have one issue. when i am trying to open the drop button, it is not working in Google Chrome and Mizilla Browser. Can you please provide any solution for that.


  2. Great Work Vishal ! Thanks for sharing your knowledge :))

  3. This comment has been removed by the author.

  4. Thank you,good explanation..step by step

  5. Really HelpFull .... thank you

  6. SSRS - Deploying Reports on the Report Server
    Report deployment comes after developing the report. To visualize the report to the end users/business users, we need to deploy the report on the report server. So, there is lots of techniques to deploy the report on the report server. In the section, we will go through them step by steps.
    SSRS - Deploying Reports on the Report Server

  7. Great Article... Thanks a ton !!!!

  8. how to deploy by using RS utility? what is the step and script required?

  9. I am getting this error while deploying :
    The permissions granted to user are insufficient for performing this operation.

  10. Agen Cock Fight Yang Siap Melayani Anda Dengan Cepat, Sopan Dan Ramah

  11. Thanks you for sharing the article. The data that you provided in the blog is infromative and effectve. Through you blog I gained so much knowledge. Also check my collection at MSBI online courseBlog

  12. I am not very good at writing, after I saw this very good website, I became excited to write smarter.

  13. a very useful website, very good to always remember and must be taken care of thanks for the information.

    Bisnis Kuliner Online

  14. A very good website, I have never found a website like this, it always works.

    Game Online Terburuk

    Game Online Steam

  15. I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post.

    Togel Hongkong Terpercaya



    Yang Merupakan Agen Bandarq, Domino 99, Dan Bandar Poker Online Terpercaya di asia hadir untuk anda semua dengan permainan permainan menarik dan bonus menarik untuk anda semua

    Bonus yang diberikan NagaQQ :
    * Bonus rollingan 0.5%,setiap senin di bagikannya
    * Bonus Refferal 10% + 10%,seumur hidup
    * Bonus Jackpot, yang dapat anda dapatkan dengan mudah
    * Minimal Depo 15.000
    * Minimal WD 20.000

    Memegang Gelar atau title sebagai AGEN BANDARQ Terbaik di masanya

    Games Yang di Hadirkan NagaQQ :
    * Poker Online
    * BandarQ
    * Domino99
    * Bandar Poker
    * Bandar66(NEW GAMES)

    Info Lebih lanjut Kunjungi :
    Website : NAGAQQ
    WHATSAPP : +855967014811
    Line : Cs_nagaQQ
    TELEGRAM :+855967014811

    berita nagaqq/
    agen bandarq online/
    Kemenangan NagaQQ/

  17. Nikmati Bonus Menarik Dari Bolavita Sekarang...
    -Nikmati Bous New member 10%
    -Nikmati Bonus Cashback Hingga 10%
    -Nikmati Juga Bonus jackpot Hingga Ratusan juta Rupiah Setiap harinya...

    Info Lengkap Hubungi:
    WA : 0812-2222-995
    Line : cs_bolavita
    Link :



  18. Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training

  19. They're the perfect webapps for streaming. Natnit Blog