November 14, 2018 at 10:18 am
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?
In my SQL Server Management Studio "v17.9" About window, here are the listed versions:
Microsoft SQL Server Management Studio 14.0.17285.0
Microsoft Analysis Services Client Tools 14.0.1016.283
Microsoft Data Access Components (MDAC) 10.0.10586.0
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.10586.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.10586
November 14, 2018 at 10:48 am
That's got to be a pretty old tutorial if it's referring to Reporting Services 2005; that's well out of support now. The deployment model has change a little bit since then. Perhaps you might be better off explaining what you actually trying to achieve here and then we can guide you through it instead.
Also, the version of SSMS is meaningless here I'm afraid; it's basically completely unrelated to SSRS apart from by name on modern SQL Server installations. We need your version and edition of SQL Server ideally here; for example SQL Server 2016 Express with Extended Tools, or SQL Server 2017 Enterprise Edition.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 14, 2018 at 12:46 pm
Here is the last of a series of article by Kathi Kellenberger which quickly explains the basics of SSRS.
Start by reading Part1 and Part4.
November 14, 2018 at 1:02 pm
There are two main ways to create and publish SSRS reports. The first is to use Report Builder and the second is Visual Studio but you need to install SQL Server Data Tools along with it.
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017
If you are new SSRS you might be more comfortable with Report Builder as it definately looks and feels like an Office product. Visual Studio is a little more advanced but I prefer it for a few things but mainly because I can build multiple reports under one project. From the application it's a matter of configuing it to point to your SSRS endpoint. By default it will be something like http://servername/ReportServer but this is can be changed under Report Services Configuration Manager.
Don't be looking at SSMS...that won't help you for this.
November 14, 2018 at 1:28 pm
You can also manually upload files using Report Manager or Report Portal. There is an upload button available to load the rdl file for a report.
And another option is to use RS.exe utility. You basically write vbscript, save the file with the rss extenstion and the code accesses the Web Service, SOAP API for SSRS.
The easiest way to just load one report to see how it's working may be just uploading it from Report Manager, Report Portal. How you deploy reports going forward is going to depend more on your environment, development methods, personal preferences, etc. If you're new, you may want to try playing around with a few different ways just to get an idea of how they work.
Sue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply