Try our new research platform with insights from 80,000+ expert users
Senior Consultant, Enterprise Data Management and Governance at a financial services firm with 501-1,000 employees
Consultant
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.

Buyer's Guide
Microsoft SQL Servering Services
May 2025
Learn what your peers think about Microsoft SQL Server Reporting Services. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.

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 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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Chief Information Officer at Solutions Business Technology
Real User
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Microsoft SQL Servering Services
May 2025
Learn what your peers think about Microsoft SQL Server Reporting Services. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
IT Architect at a computer software company with 1,001-5,000 employees
Real User
Top 20
Helps to create dashboards and important reports for project management
Pros and Cons
  • "We can create quality reports in real time."
  • "We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."

What is our primary use case?

We use the solution to create dashboards and important reports for project management. 

How has it helped my organization?

We can create quality reports in real time. 

What is most valuable?

I like the tool's usability. 

What needs improvement?

We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive. 

For how long have I used the solution?

I have been using the solution for more than five years. 

What do I think about the stability of the solution?

I would rate the solution a nine out of ten. 

What do I think about the scalability of the solution?

I would rate Microsoft SQL Server Reporting Services' scalability a seven out of ten. 

How are customer service and support?

I did not have good experience with Microsoft SQL Server Reporting Services' support at times. 

How would you rate customer service and support?

Negative

What other advice do I have?

I would rate the product a seven out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1634091 - PeerSpot reviewer
Senior Manager at a consultancy with 10,001+ employees
Real User
Comes with automated reporting feature but interface is old
Pros and Cons
  • "I like Microsoft SQL Server Reporting Services' automated reporting feature."
  • "The solution's interface is old."

What is our primary use case?

We use the tool to report for businesses. 

What is most valuable?

I like Microsoft SQL Server Reporting Services' automated reporting feature. 

What needs improvement?

The solution's interface is old. 

For how long have I used the solution?

I have been working with the solution for five years. 

What do I think about the stability of the solution?

The tool is stable. 

How are customer service and support?

I have never used technical support. 

How was the initial setup?

Microsoft SQL Server Reporting Services' initial setup depends on knowledge and I would rate it a six or seven out of ten. 

What other advice do I have?

I would rate the tool a seven out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free Microsoft SQL Server Reporting Services Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2025
Product Categories
Reporting
Buyer's Guide
Download our free Microsoft SQL Server Reporting Services Report and get advice and tips from experienced pros sharing their opinions.