We just raised a $30M Series A: Read our story

Microsoft SQL Server Reporting Services OverviewUNIXBusinessApplication

Microsoft SQL Server Reporting Services is #12 ranked solution in top Reporting Tools. IT Central Station users give Microsoft SQL Server Reporting Services an average rating of 8 out of 10. Microsoft SQL Server Reporting Services is most commonly compared to IBM Cognos:Microsoft SQL Server Reporting Services vs IBM Cognos. The top industry researching this solution are professionals from a computer software company, accounting for 23% of all views.
What is Microsoft SQL Server Reporting Services?

At Microsoft, our mission is to empower every person and every organization on the planet to achieve more. Our mission is grounded in both the world in which we live and the future we strive to create. Today, we live in a mobile-first, cloud-first world, and the transformation we are driving across our businesses is designed to enable Microsoft and our customers to thrive in this world.

We do business in 170 countries and are made up of 114,000 passionate employees dedicated to fulfilling our mission of helping you and your organization achieve more.

Microsoft SQL Server Reporting Services was previously known as SQL Server Reporting Services, Microsoft SSRS, SSRS, MS SQL Server Reporting Services.

Buyer's Guide

Download the Reporting Tools Buyer's Guide including reviews and more. Updated: November 2021

Microsoft SQL Server Reporting Services Customers
CMS Wire, The New York Times
Microsoft SQL Server Reporting Services Video

Pricing Advice

What users are saying about Microsoft SQL Server Reporting Services pricing:
  • "The price is pretty good."

Microsoft SQL Server Reporting Services Reviews

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Michael-Brooks
Chief Information Officer at Solutions Business Technology
Real User
Top 10
Well packaged and easy to figure out but needs better visualization

Pros and Cons

  • "The solution's features are all just wrapped up in one nice easy package. I don't need a lot of toolsets to get everything I need done."
  • "It doesn't have quite the flexibility of a Tableau or something like that. Many users are more comfortable with Tableau and I'm not quite sure why that is right now, but it seems to be the case."

What is our primary use case?

In one particular case, we had reporting issues and we were sucking data off of a couple of different systems into a data monitor. You might call it a data rig now. Due to the fact that we did that, we were using the transformation pieces to pull it into that data monitoring, and put out some operational-type reports.

The fun part about it was because we could do a lot with it and it didn't need necessarily another layer reports. It was pretty much encapsulated well already. 

What is most valuable?

The solution's features are all just wrapped up in one nice easy package. I don't need a lot of toolsets to get everything I need done.

It's not a difficult solution to figure out.

What needs improvement?

It doesn't have quite the flexibility of a Tableau or something like that. Many users are more comfortable with Tableau and I'm not quite sure why that is right now, but it seems to be the case.

The visualization needs improvement. They're lacking. Once again, Tableau is better in this respect. Basically taking the data and visualizing it onto the different types of reports and stuff like that needs to get better.

For how long have I used the solution?

I've been using the solution for the last twelve years or so.

What do I think about the stability of the solution?

On-premises, I've never had stability issues with its exception of the original versions. It's safe to say the solution is quite stable at this point. For me, at least, it's been stable. I don't think I have a problem with it in that sense. It doesn't crash or freeze and I can't say it's buggy or glitchy.

What do I think about the scalability of the solution?

The solution doesn't scale horizontally. 

From a vertical scalability standpoint, it's fine. It depends on the same issues that all relational databases do. Even if you set it up for reporting, etc. However, from a horizontal scaling, it really wasn't the way that it was designed. At the end of the day, I don't really know. I haven't used it for scaling purposes personally and don't even know if it's capable of scaling horizontally.

We probably only have about 100 users on the solution. It's not a lot. We just use it for a financial app.

How are customer service and technical support?

Typically, if a company has bad consultants, they need to contact technical support a lot. However, we have a very good understanding of the product, so that's not usually necessary.

Which solution did I use previously and why did I switch?

We've previously used a lot of different products, including Oracle OBIEE and Oracle Business Intelligence Discoverer. Discover is quite old. Most people wouldn't even know what it is. 

How was the initial setup?

The initial setup question is a tricky one to answer. It depends on what you call easy. Some implemented well, and it was due to the fact that we put it in a monitor because the data didn't join well and we had some bigger data management issues. Some people would call that complex, and yet, it's pretty normal as to why you put something into a monitor.

On a smaller deployment, it was probably a couple of months of work. The process was probably only 200 man-hours to get what we needed out of it. It wasn't a huge deal.

The solution doesn't need too much maintenance. It would've just been something that once it was done, the normal staff just go ahead and do the maintenance. That's after the ETL programs are built, and so on. Maintenance is not a big deal. We can pretty much figure everything out. 

Which other solutions did I evaluate?

We compare a few different solutions. Tableau is usually easier for users to get behind as it's a bit simpler to use. It has good visualization.

What other advice do I have?

I'm not sure which version of the solution we are currently using. We've updated it a few times over the years.

I'd advise other users to just to be really clear on what you're trying to accomplish. You've got to make sure it's the right product for what you're trying to do.

I'd rate the solution seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Jayesh Narani
Senior Consultant, Enterprise Data Management and Governance at a financial services firm with 501-1,000 employees
Consultant
Top 5
Intuitive to use, excellent technical support, and it is easy to get data whenever we need it

Pros and Cons

  • "The SQL Server Reporting Services makes it very easy to get the data whenever we need it."
  • "Technical support is in minor need of improvement so that they can solve problems in a more timely manner."

What is our primary use case?

We use this product to store all of the bank's data.

How has it helped my organization?

The SQL Server Reporting Services makes it very easy to get the data whenever we need it.

What is most valuable?

We are also using it as a manual data quality tool, where we can write the queries and then generate reports based on the data that we have.

The interface is intuitive.

What needs improvement?

Technical support is in minor need of improvement so that they can solve problems in a more timely manner. Some of them take too long to solve.

For how long have I used the solution?

I have been using this product for approximately eight years.

What do I think about the stability of the solution?

Although we had issues with stability, they were network-related issues and had nothing to do with the product itself.

What do I think about the scalability of the solution?

Scalability-wise, it is good. There are more than 50 people currently using it in my organization. Their roles are from the director down to the analyst level.

How are customer service and technical support?

Technical support is excellent and I would rate them a nine out of ten.

My only complaint about the technical support is that sometimes, they don't solve the problem immediately.

Which solution did I use previously and why did I switch?

I have been using this solution since the beginning and we did not switch.

How was the initial setup?

The initial setup was straightforward.

What's my experience with pricing, setup cost, and licensing?

The price is pretty good.

Which other solutions did I evaluate?

Next year, we will be completely moving to the cloud in Azure where we will be building data factories.

What other advice do I have?

My advice to anybody who is implementing this product is to consider that it is straightforward to use, and given that it is Microsoft, they can move to the cloud at any time with Azure.

For me, I have never had any trouble using this product. 

Overall, we are very much satisfied with this product. I find it user-friendly and there are minimum outages. We did have problems related to our network but as an application, it's excellent. Our only complaint is that technical support wasn't always able to help us right away.

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Product Categories
Reporting Tools
Buyer's Guide
Download our free Reporting Tools Report and find out what your peers are saying about Microsoft, IBM, Tableau, and more!