none
How to create SetUp to deploy SSRS reports on production server. RRS feed

  • Question

  • Hi,
       I have created SSRS reports and deployed the same by using the DEPLOY option which pop up when i right click on the SSRS solution.
      But now the CLIENT wants that i should provide him a setup, so that he himself can deploy the report.
      Please advice how can i create a setup to deploy SSRS.

    Your suggestions are highly appreciable.

    Thanks & Regards
    Baljeet Kiroriwal

    Monday, December 21, 2009 5:36 AM

Answers

  • Hi Baljeet,

    You probably mean packaging the solution and then including it in your installation process? Well, I have not seen it done, but there may be a way. RsScripter is the utility that is most commonly used for deployment (after admins deploying directly from BIDS).

    Boyan Penev --- http://www.bp-msbi.com
    Monday, December 21, 2009 8:51 PM
  • Hi Baljeect,

    By default, we have also provided a script utiltiy named "RS". This utility is used to process script we provide in an input file. Use this utility to automate report server deployment and administration tasks.

    Also, we can use the method "CreateReport" in the SQL Server Reporting Services web service  to publish reports to report server. We can invoke the web service in a VB application, and then call the "CreateReport" method to publish reports.

    By the way, if we have installed SQL Server Reporting Services production sample, we can find a script sample that used to publish report:
    By default, the file is located at: C:\Program Files\Microsoft SQL Server\100\Samples\Reporting Services\Script Samples\PublishSampleReports.rss

    For more information, please see:
    rs Utility: http://msdn.microsoft.com/en-us/library/ms162839.aspx
    ReportingService2005.CreateReport Method: http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.createreport.aspx

    If you have any more questions, please feel free to ask.

    Thanks,
    Jin Chen

    Jin Chen - MSFT
    Tuesday, December 22, 2009 10:12 AM
    Moderator

All replies

  • Hi Baljeet,

    I probably do not understand the idea behind a client deploying reporting services reports - is it for the admins to be able to deploy to production? If so, you can use RsScripter:

    http://www.sqldbatips.com/showarticle.asp?ID=62

    http://weblogs.asp.net/akjoshi/archive/2009/01/29/using-rs-scripter-to-create-deployment-script-for-reporting-services.aspx


    Boyan Penev --- http://www.bp-msbi.com
    Monday, December 21, 2009 5:50 AM
  • Hi Boyan,
        i have generated the script and it worked fine for me.  Thanks for your great suggestion.
        Can you please advise me, is there any other way apart from this scripting method.(e.g. can we make a setup like as we do while publish the website OR we create the setup for a VB 6.0 project.)


    Many Many Thanks for you above reply.

    Thanks & Regards
    Baljeet Kiroriwal
      
    Monday, December 21, 2009 10:00 AM
  • Hi Baljeet,

    You probably mean packaging the solution and then including it in your installation process? Well, I have not seen it done, but there may be a way. RsScripter is the utility that is most commonly used for deployment (after admins deploying directly from BIDS).

    Boyan Penev --- http://www.bp-msbi.com
    Monday, December 21, 2009 8:51 PM
  • Hi Baljeect,

    By default, we have also provided a script utiltiy named "RS". This utility is used to process script we provide in an input file. Use this utility to automate report server deployment and administration tasks.

    Also, we can use the method "CreateReport" in the SQL Server Reporting Services web service  to publish reports to report server. We can invoke the web service in a VB application, and then call the "CreateReport" method to publish reports.

    By the way, if we have installed SQL Server Reporting Services production sample, we can find a script sample that used to publish report:
    By default, the file is located at: C:\Program Files\Microsoft SQL Server\100\Samples\Reporting Services\Script Samples\PublishSampleReports.rss

    For more information, please see:
    rs Utility: http://msdn.microsoft.com/en-us/library/ms162839.aspx
    ReportingService2005.CreateReport Method: http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.createreport.aspx

    If you have any more questions, please feel free to ask.

    Thanks,
    Jin Chen

    Jin Chen - MSFT
    Tuesday, December 22, 2009 10:12 AM
    Moderator
  • Hi Boyan,
         as per your guidance i created the script and when i client run this script on production server. It came up with error :-
            Running script "C:\tempReportDirectory\Data Sources\dsAriannaReports.rds.rss"
            Error : rsItemNotFound (The item '/Data Sources' cannot be found.)


    As i have run the script from path "c:\tempReportDirectory".

    But in the GUI appearance of RSScripter.exe i have checked the create "Data Sources" as well.

    I am confused why this is happening. If you have come across this issue please help me..


    Regards

    Baljeet Kiroriwal

     

    Wednesday, December 30, 2009 4:48 AM
  • Hi Jin Chen,

         I have created a script using "RSScripter.exe" , When My client run this script on production server. It came up with error :-
            Running script "C:\tempReportDirectory\Data Sources\dsAriannaReports.rds.rss"
            Error : rsItemNotFound (The item '/Data Sources' cannot be found.)


    As i have run the script from path "c:\tempReportDirectory".

    But in the GUI appearance of RSScripter.exe i have checked the create "Data Sources" as well.

    I am confused why this is happening. If you have come across this issue please help me..


    Regards

    Baljeet Kiroriwal

    Wednesday, December 30, 2009 4:50 AM
  • Hi Baljeet,

    The error "The item '/Data Sources' cannot be found" means the folder "Data Sources" is not existing in the report server.

    I would suggest you checking if the folder is in the report server.

    Or, please paste the script file in this thread, that will help us to solve the issue.

    Thanks,
    Jin Chen
    Jin Chen - MSFT
    Wednesday, December 30, 2009 7:26 AM
    Moderator