Starting out and new to SSRS — How do I “deploy the report” and add a web reference?










0















I am new to SSRS. I have gone through some tutorials in the online Microsoft "docs" pages and I have seen how to create a report. Now, I am looking at a tutorial (on a different web site) with eager anticipation to start making programmatically generated reports of my own. This tutorial has these two first steps:



 Step 1: Create and deploy the report. 

Step 2: Add a web reference to the web services exposed by Reporting Services 2005, i.e., ReportExecution2005 and ReportService2005.


So, I know how to create a report (by hand), but, how do I deploy the report?



And how exactly do I add a web reference to the web service exposed by Reporting Services?










share|improve this question




























    0















    I am new to SSRS. I have gone through some tutorials in the online Microsoft "docs" pages and I have seen how to create a report. Now, I am looking at a tutorial (on a different web site) with eager anticipation to start making programmatically generated reports of my own. This tutorial has these two first steps:



     Step 1: Create and deploy the report. 

    Step 2: Add a web reference to the web services exposed by Reporting Services 2005, i.e., ReportExecution2005 and ReportService2005.


    So, I know how to create a report (by hand), but, how do I deploy the report?



    And how exactly do I add a web reference to the web service exposed by Reporting Services?










    share|improve this question


























      0












      0








      0








      I am new to SSRS. I have gone through some tutorials in the online Microsoft "docs" pages and I have seen how to create a report. Now, I am looking at a tutorial (on a different web site) with eager anticipation to start making programmatically generated reports of my own. This tutorial has these two first steps:



       Step 1: Create and deploy the report. 

      Step 2: Add a web reference to the web services exposed by Reporting Services 2005, i.e., ReportExecution2005 and ReportService2005.


      So, I know how to create a report (by hand), but, how do I deploy the report?



      And how exactly do I add a web reference to the web service exposed by Reporting Services?










      share|improve this question
















      I am new to SSRS. I have gone through some tutorials in the online Microsoft "docs" pages and I have seen how to create a report. Now, I am looking at a tutorial (on a different web site) with eager anticipation to start making programmatically generated reports of my own. This tutorial has these two first steps:



       Step 1: Create and deploy the report. 

      Step 2: Add a web reference to the web services exposed by Reporting Services 2005, i.e., ReportExecution2005 and ReportService2005.


      So, I know how to create a report (by hand), but, how do I deploy the report?



      And how exactly do I add a web reference to the web service exposed by Reporting Services?







      sql reporting-services






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 12 at 13:24









      Cœur

      18.9k9110153




      18.9k9110153










      asked Nov 14 '18 at 16:51









      xarzuxarzu

      3,3533085128




      3,3533085128






















          1 Answer
          1






          active

          oldest

          votes


















          1














          To Deploy:



          In the reporting services project, set the TargetServerURL property to your Reporting Services server (typically http://<servername>/reportserver), then Build>Deploy to deploy all reports in the project or right-click on a single report and choose to deploy just that report See https://docs.microsoft.com/en-us/sql/reporting-services/reports/publishing-reports-to-a-report-server?view=sql-server-2017 for screenshots and more details.



          Web References:



          If you're following tutorials that expect a web reference and you're using Visual Studio 2017, go to Project>Add Service Reference, click "Advanced...", then "Add Web Reference..." (older versions of Visual Studio had "Add Web Reference" as an option on the Project Menu but it's harder to find in VS2017) For ReportExecution, the path is usually http://<servername>/reportserver/ReportExecution2005.asmx ReportService should be the same except replace "Execution" with "Service" in the name.



          Example Usage:



          https://docs.microsoft.com/en-us/dotnet/api/reportexecution2005.reportexecutionservice.render?view=sqlserver-2016 has a detailed example of saving a report to MHTML in VB or C# using the ReportExecution service (you can pick the language from the </> button near the top/right of the page). You can also save to PDF and other various formats - see the "format" parameter notes in this link






          share|improve this answer






















            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53305152%2fstarting-out-and-new-to-ssrs-how-do-i-deploy-the-report-and-add-a-web-refer%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            1














            To Deploy:



            In the reporting services project, set the TargetServerURL property to your Reporting Services server (typically http://<servername>/reportserver), then Build>Deploy to deploy all reports in the project or right-click on a single report and choose to deploy just that report See https://docs.microsoft.com/en-us/sql/reporting-services/reports/publishing-reports-to-a-report-server?view=sql-server-2017 for screenshots and more details.



            Web References:



            If you're following tutorials that expect a web reference and you're using Visual Studio 2017, go to Project>Add Service Reference, click "Advanced...", then "Add Web Reference..." (older versions of Visual Studio had "Add Web Reference" as an option on the Project Menu but it's harder to find in VS2017) For ReportExecution, the path is usually http://<servername>/reportserver/ReportExecution2005.asmx ReportService should be the same except replace "Execution" with "Service" in the name.



            Example Usage:



            https://docs.microsoft.com/en-us/dotnet/api/reportexecution2005.reportexecutionservice.render?view=sqlserver-2016 has a detailed example of saving a report to MHTML in VB or C# using the ReportExecution service (you can pick the language from the </> button near the top/right of the page). You can also save to PDF and other various formats - see the "format" parameter notes in this link






            share|improve this answer



























              1














              To Deploy:



              In the reporting services project, set the TargetServerURL property to your Reporting Services server (typically http://<servername>/reportserver), then Build>Deploy to deploy all reports in the project or right-click on a single report and choose to deploy just that report See https://docs.microsoft.com/en-us/sql/reporting-services/reports/publishing-reports-to-a-report-server?view=sql-server-2017 for screenshots and more details.



              Web References:



              If you're following tutorials that expect a web reference and you're using Visual Studio 2017, go to Project>Add Service Reference, click "Advanced...", then "Add Web Reference..." (older versions of Visual Studio had "Add Web Reference" as an option on the Project Menu but it's harder to find in VS2017) For ReportExecution, the path is usually http://<servername>/reportserver/ReportExecution2005.asmx ReportService should be the same except replace "Execution" with "Service" in the name.



              Example Usage:



              https://docs.microsoft.com/en-us/dotnet/api/reportexecution2005.reportexecutionservice.render?view=sqlserver-2016 has a detailed example of saving a report to MHTML in VB or C# using the ReportExecution service (you can pick the language from the </> button near the top/right of the page). You can also save to PDF and other various formats - see the "format" parameter notes in this link






              share|improve this answer

























                1












                1








                1







                To Deploy:



                In the reporting services project, set the TargetServerURL property to your Reporting Services server (typically http://<servername>/reportserver), then Build>Deploy to deploy all reports in the project or right-click on a single report and choose to deploy just that report See https://docs.microsoft.com/en-us/sql/reporting-services/reports/publishing-reports-to-a-report-server?view=sql-server-2017 for screenshots and more details.



                Web References:



                If you're following tutorials that expect a web reference and you're using Visual Studio 2017, go to Project>Add Service Reference, click "Advanced...", then "Add Web Reference..." (older versions of Visual Studio had "Add Web Reference" as an option on the Project Menu but it's harder to find in VS2017) For ReportExecution, the path is usually http://<servername>/reportserver/ReportExecution2005.asmx ReportService should be the same except replace "Execution" with "Service" in the name.



                Example Usage:



                https://docs.microsoft.com/en-us/dotnet/api/reportexecution2005.reportexecutionservice.render?view=sqlserver-2016 has a detailed example of saving a report to MHTML in VB or C# using the ReportExecution service (you can pick the language from the </> button near the top/right of the page). You can also save to PDF and other various formats - see the "format" parameter notes in this link






                share|improve this answer













                To Deploy:



                In the reporting services project, set the TargetServerURL property to your Reporting Services server (typically http://<servername>/reportserver), then Build>Deploy to deploy all reports in the project or right-click on a single report and choose to deploy just that report See https://docs.microsoft.com/en-us/sql/reporting-services/reports/publishing-reports-to-a-report-server?view=sql-server-2017 for screenshots and more details.



                Web References:



                If you're following tutorials that expect a web reference and you're using Visual Studio 2017, go to Project>Add Service Reference, click "Advanced...", then "Add Web Reference..." (older versions of Visual Studio had "Add Web Reference" as an option on the Project Menu but it's harder to find in VS2017) For ReportExecution, the path is usually http://<servername>/reportserver/ReportExecution2005.asmx ReportService should be the same except replace "Execution" with "Service" in the name.



                Example Usage:



                https://docs.microsoft.com/en-us/dotnet/api/reportexecution2005.reportexecutionservice.render?view=sqlserver-2016 has a detailed example of saving a report to MHTML in VB or C# using the ReportExecution service (you can pick the language from the </> button near the top/right of the page). You can also save to PDF and other various formats - see the "format" parameter notes in this link







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 14 '18 at 17:46









                Shawn PenceShawn Pence

                14125




                14125





























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53305152%2fstarting-out-and-new-to-ssrs-how-do-i-deploy-the-report-and-add-a-web-refer%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Kleinkühnau

                    Makov (Slowakei)

                    Peter Parker: The Spectacular Spider-Man #308