Microsoft SQL Server Reporting Services Reviews

We use the solution mainly for the KPIs and dashboards.

I mainly use the solution for the ease of reporting and for executive dashboards.

I'm starting to use Power BI this year, and it would be really nice to have better integration between the solution and Power BI.

I have been using Microsoft SQL Server Reporting Services since 2015.

Microsoft SQL Server Reporting Services is a stable solution.

I rate the solution an eight out of ten for stability.

Microsoft's support is not generally good, but I haven't had to deal with it. I would only use Microsoft support for the licensing part, which is very complex for SQL Server.

When I was relatively new to it, the solution's initial setup was complex for me. On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup a three or four out of ten.

According to me, the solution's pricing is very expensive, but I don't know how much Oracle or other competitors would cost. Since I am unfamiliar with other pricing schemes, the solution's pricing may be fair. Getting the type of license we bought was very complicated. Value-wise, the solution's pricing is good for the price that we pay. I rate the solution a seven out of ten for the value we received from the solution's pricing.

The solution's data visualization capabilities have helped enhance our reporting and made my life easier. I don't have to deal with third-party software.

The solution's integration with other tools and systems has proved to be a time-saver. The solution's integration saved me a few weeks out of a year on a lot of analytics. I would recommend the solution to other users.

Overall, I rate the solution a seven out of ten.

Microsoft SQL Server Reporting Services needs to improve performance.

I have been using the product for six to seven years. 

Microsoft SQL Server Reporting Services is stable. 

The solution is scalable. My company has 25 users for the product. 

We get good support from Microsoft. 

The tool's deployment complexity is medium. 

Microsoft SQL Server Reporting Services can be deployed in-house. 

The tool's licensing costs are expensive. 

I rate Microsoft SQL Server Reporting Services an eight out of ten. 

We use the solution to generate reports for end customers and our organization.

The solution mainly provides capabilities to generate reports which can be consumed by end consumers and our business as well. There is no need to go for an alternative platform.

We encounter some barriers while building a report. They should improve numerous areas related to reporting. Also, it is difficult to implement some of the features. It needs improvement as well.

We have been using the solution for one year.

I rate the solution's stability a nine out of ten.

Our clients have 4000 registered users for the solution. I rate its scalability an eight out of ten. It is suitable for small to enterprise businesses.

I refer to research forums and the web to find the answers to technical queries for the solution. 

I have set up a single server, port server, and report server software for the solution. I have basically done a full setup for the local environment. I rate its initial setup process a seven out of ten based on the experience. It was straightforward and took about a day to complete. The deployment involves installing and configuring it. Further, it needs to set up a database and provide additional configuration options.

The solution is free to use for developers.

If you have prior experience working with databases, the solution is easy to understand. Otherwise, it would be somewhat complicated.

I rate it a seven out of ten.

We use it to create reports within our internal systems, specifically our proprietary systems. So it's integrated into our existing applications.

We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities.

It's integrated, making it easier to use. It also provides better functionality within the SQL Server BI toolset.

There is room for improvement in the pricing model. The overall suite, including the BI suite, is expensive.

I have had a good number of years of experience.

It's pretty solid. It is a stable solution.

It's pretty scalable.

I usually refer to the FAQs for assistance.

The initial setup is pretty straightforward. 

I would rate my experience with the initial setup a seven out of ten, with one being complex and ten being easy. 

For the most part, the deployment takes a couple of days to install.

Around four people were involved in the deployment process. 

The ROI was not in monetary terms, but it has certainly improved usability and added extensive reporting within our internal toolset.

So, it saves time and improves efficiency.

 The suite itself is expensive due to the licensing model.

Overall, I would rate the pricing model a seven out of ten, with one being the cheapest and ten being the most expensive.

The decision should be made based on your usage of other Microsoft suite products. I would rate it an eight out of ten because of its feature set and its compatibility with other Microsoft BI toolsets.

When the data source is Microsoft-related, like, Excel or Microsoft products in general, I prefer to use SSRS. The most important thing is I can export the data from different formats at the end. This is one of the main features we love of the SQL Server, SSRS.

There is room for improvement in the setup process. The setup is difficult because you have to install different servers. It's complicated because it stops working and does not have support. We don't have a version for Mac. We have some developers who use Mac, so it's hard to provide them with the product they have to use and the virtualization.

I use SSRS when I need to extract the data. So, I have never had a long-term experience with it, but whenever there is a database that I need to extract the data, I use SSRS.

Once it is working, it will be stable. But sometimes, the performance is a little bit slow when you have larger data sets, when the data is used.

It is scalable. So in terms of scalability, it is scalable as long as it is on a Microsoft platform.

The customer service and support are effective. 

Positive

I would rate the initial setup a seven out of ten in terms of the easiness of the softness of the setup.

Once we configure it, there are no changes in the data structure. Then it is easy to maintain. But if the customers are modifying or having new releases, then it is not easy to maintain. Also, it's not easy to document the setup of SSRS. You have to work or document that externally, and it requires writing the documentation. Some of the engineers who got the script or the network figured out but then they leave, you have to bring another one, and you have to walk them through all the steps to understand. It is not easy to document.

It is not expensive compared to other platforms. So, if ten was the most expensive product and one was the cheapest, I would rate the pricing of this product around seven out of ten.

If your data source is on Microsoft, then I would recommend using SSRS. If your data source is different, I would recommend that you have any kind of APIs or something before they connect to Microsoft.

Overall, I would rate Microsoft SQL Server Reporting Services an eight out of ten. I think it will be fair.

Sometimes, the tool is needed for scheduled reporting and sometimes for dashboards. Scheduled reports can be sent as email, links or displayed on dashboards. SSRS can be integrated into dashboards. 

The tool's valuable features are its drill-down feature, graphs, and charts. 

Tableau is more user-friendly because it doesn't need to do any extra programming. It has drag-and-drop functionality.

I have been using the product since 2012. 

I would rate the tool's stability a ten out of ten. Once designed and integrated into the dashboard, it doesn't break unless there's an issue with the data or the connectivity to the database.

Many people find Tableau more scalable than SSRS. I rate its scalability an eight out of ten. 

When we create a case with the tool, their support responds and ensures the issue is resolved. A security management task was resolved within a week. It was a complex task but completed within the anticipated timeframe.

Positive

The initial setup was not exactly complex. If you know your way around, it's quite straightforward.

I rate SSRS as nine out of ten. 

We use the product to build reports based on customer requirements. It also helps us to export documents to different formats like Excel, CSV, and Word document and share it through emails or FTP. 

I am impressed with the product's seamless integration. It can work with different databases like Oracle. 

I would like the solution to add a scheduling feature for reports. 

I have been using the solution for 10-15 years. 

I would rate the product's stability an eight out of ten. 

I am not sure about the tool's scalability since we haven't tried deploying it on multiple servers. 

Microsoft's support is good. 

Positive

I would rate the product's setup a seven out of ten. The tool's deployment takes a couple of days to complete. Microsoft provides installation media when you purchase the license. You need to do a verification after the deployment and configuration. 

The solution is cheaper than its alternatives. 

I would rate the solution a seven out of ten. You need to use the solution if your technology stack is Microsoft and the backend database is an SQL server. 

We use the tool to report for businesses. 

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

The solution's interface is old. 

I have been working with the solution for five years. 

The tool is stable. 

I have never used technical support. 

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

I would rate the tool a seven out of ten. 

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

We can create quality reports in real time. 

I like the tool's usability. 

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

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

I would rate the solution a nine out of ten. 

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

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

Negative

I would rate the product a seven out of ten. 

The use case depends on the requirements of the system or applications. Organizations and individuals may use the product for different purposes ranging from small-scale applications to enterprise-level systems.

The solution is known for its robust security features. It is an excellent product. It is a widely used database management system.

The product should improve its performance. It should improve the optimization, encryption and access control. It should provide efficient resource management features.

I am currently using the solution.

The solution is stable. I rate the stability a ten out of ten.

I had a good experience with technical support.

The initial setup is easy.

The solution is expensive.

I would recommend the solution to others. Overall, I rate the product a ten out of ten.