Starting out and new to SSRS — How do I “deploy the report” and add a web reference?
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
add a comment |
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
add a comment |
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
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
sql reporting-services
edited Jan 12 at 13:24
Cœur
18.9k9110153
18.9k9110153
asked Nov 14 '18 at 16:51
xarzuxarzu
3,3533085128
3,3533085128
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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
add a comment |
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
add a comment |
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
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
answered Nov 14 '18 at 17:46
Shawn PenceShawn Pence
14125
14125
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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