Create SSRS reports on my Workstation

Question

Create SSRS reports on my Workstation

aberndt

SSCrazy

Points: 2003
More actions
May 15, 2015 at 1:04 pm

#398469

I have a SQL Server running SQL Server 2012. SSRS is installed and running on the server and the Report Server databases are present. What do I need to install on my workstation to be able to create SSRS reports? When I was running SQL Server 2008, I had Report Builder and Visual Studio installed on my workstation. I didn't use them much and I believe the installation is different for 2012. Please forgive me for my basic question but I don't want to do anything wrong that could cause problems on a production server. Thank you in advance for your help.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

JeremyE SSCoach Points: 16119 More actions · Answer 1

You need to install SQL Server Data Tools on your workstation. It is in the shared features section when you run the SQL 2012 install.

aberndt SSCrazy Points: 2003 More actions · Answer 2

Thank you for the prompt response. I will do that. Once it is installed, how do I connect to the existing Report Server?

JeremyE SSCoach Points: 16119 More actions · Answer 3

You don't need to connect to the Report Server to build reports. You can build them on your workstation and then deploy them to the Report Server. If you are more comfortable using Report Builder, the 2012 download is here: https://www.microsoft.com/en-us/download/details.aspx?id=29072

aberndt SSCrazy Points: 2003 More actions · Answer 4

Thank you. I appreciate your help! I took a class in SSRS for 2008 a couple of years ago, I just never did anything with it as I stuck with my Crystal Reports. Are there any other resources you would recommend to get me going? I don't want to keep pestering you 🙂

JeremyE SSCoach Points: 16119 More actions · Answer 5

Here are some basic tutorials: https://msdn.microsoft.com/en-us/library/bb522859.aspx

Channel 9 also has webinars about RS: https://channel9.msdn.com/Tags/sql+server+reporting+services

pietlinden SSC Guru Points: 63421 More actions · Answer 6

there are a bunch of SSRS tutorials from super simple to reasonably complicated on YouTube... look up WiseOwl. Worked for me. (because you can watch, stop, try, watch...)

Alan Burstein SSC Guru Points: 61136 More actions · Answer 7

For a great tutorial try the Stairway to SQL Server Reporting Services[/url] right here on SSC.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

aberndt SSCrazy Points: 2003 More actions · Answer 8

Thank you all for your suggestions! I really appreciate it 🙂