Can you help me with SSRS?
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?
This link describes how to create a "report definition file". So I think that how this must be done is to first have a definition file. This definition file (I assume) works like a template that data can be fed into dynamically. Is this right?
And then, I guess, the loaded definition file can be used to generate a report. Is this correct?
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
Best Answer
-
ben_b Posts: 84 Silver 2Hi - this forum is just for red-gate products. for Microsoft SSRS you are probably better off asking the question on somewhere like stack overflow or looking for a tutorial on youtube.
that said, as I am here.
you create the report in the client tool SSDT
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017
then you will need to install the server component (where you will deploy the report)
https://www.microsoft.com/en-us/download/details.aspx?id=55252
you configure your project properties and deploy from within the client tool SSDT.
cheers
Ben