CODEWITHSUNDEEP
visual-studioreporting-serviceswix
C. Williamson
C. Williamson

Reputation: 329

How do I deploy an SSRS solution?

This is an extremely vague question because I don't know enough to know what I don't know. Here's my situation:

I have downloaded SSDT and connected to a data source (A SQL Server DB instance). I've created a report. I can preview the report in VS. I can publish the report from the VS build menu and it gets published to my local reports server that seems to have been installed by default at http://localhost/reports. I can use a browser to go to that url and see the report I created.

Now, the problem is that this is all only in my local development environment. I installed SSDT through Visual Studio and it auto-created my reports server. Is there a way to install a reports server without installing visual studio and publish the reports from a report solution using an MSI created by a packager like WiX? I'm having a hard time finding information about how to do this.

Upvotes: 1

Views: 1273

Answers (1)

Alan Schofield
Alan Schofield

Reputation: 21683

The report server is typically installed when you install SQL Server. If you want to publish reports so that others can use them do the following:

  1. Go to your VS solution and right-click on the project then select properties.
  2. Set the TargetReportFolder (this will be created if it does not exist). This will usually reflect the name of the group of reports you are working on (e.g. 'HR Reports')
  3. Set the TargetServerURL to the report server on your SQL Server box for example http://mySQLServerBox/reportserver/
  4. Set the TargetServerVersion to match your SQL Server installation version (SQL Server 2016 etc)
  5. Now you can simply right-click a report rdl in VS and choose deploy, you can also do the same at the folder level to deploy all the reports in one go.

To access the reports, go to the web portal which will usually be http://MySQLServerBox/reports

I hope this is what you are looking for..

Upvotes: 2

Related Questions