Speaking about deploying and accessing reports with the help of the product, I would say that Microsoft SQL Server Reporting Services can be easily installed and deployed. While working with reports using Microsoft SQL Server Reporting Services, my company needed to write SQL queries in the background for prompts, while the interface interacting with reports was not comfortable enough for users, especially when compared with other BI tools. With Microsoft SQL Server Reporting Services, the standard reports are generated. For real-time reporting and data analysis, Microsoft SQL Server Reporting Services is used in 70 percent of our company, specifically in the collection and credit departments. The manager wants to separately analyze and freely move the data source so as to be able to find the solutions and ideas during the time owing to which they are not comfortable with Microsoft SQL Server Reporting Services. My company's managers want a good interface like the one provided by Cognos Dynamic Cubes, and because of this, I think my company plans to move to IBM Cognos Analytics in the future. On the reporting part, the dashboard attached to the tool's data visualization capability is not very interactive and doesn't offer multiple functionalities. Though I am not sure about the subscription and delivery features in the tool, I know that sending emails and reports is a good part of the product. There is a separate set of people mainly handling the migration activities of reports. One person is enough to maintain the tool. It is not easy to integrate the product with other tools in the market. Microsoft SQL Server Reporting Services integrates well with Microsoft tools. I have tried to integrate Microsoft SQL Server Reporting Services with IBM Cognos TM1. I saw that fetching data was possible when moving to Cognos Dynamic Cubes, but I saw that some data sources, by default, show zero to all the dimension values, which is why my company had to use filters to remove the zeros. The aforementioned compatibility issues are present in the product. Before choosing a product, people should have knowledge of reporting. People can use the product for standard reports but not for the analytics part. I rate the tool a six out of ten.
I would rate it an eight out of ten. Microsoft also has another solution called Power BI. Power BI is a bit more powerful, and it has more integration compared to Microsoft SQL. So, if organizations are considering using SQL Reporting Services, then it is also wise to do a comparison between Reporting Services and the newer Microsoft Power BI solution.
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.
Software Consultant at Version Two Software Solutions Limited
Reseller
Top 10
2023-07-10T14:53:00Z
Jul 10, 2023
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.
Learn what your peers think about Microsoft SQL Server Reporting Services. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
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.
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.
Senior Consultant, Enterprise Data Management and Governance at a financial services firm with 501-1,000 employees
Consultant
2020-09-22T07:16:00Z
Sep 22, 2020
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.
Chief Information Officer at Solutions Business Technology
Real User
2020-08-09T07:19:58Z
Aug 9, 2020
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.
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...
Speaking about deploying and accessing reports with the help of the product, I would say that Microsoft SQL Server Reporting Services can be easily installed and deployed. While working with reports using Microsoft SQL Server Reporting Services, my company needed to write SQL queries in the background for prompts, while the interface interacting with reports was not comfortable enough for users, especially when compared with other BI tools. With Microsoft SQL Server Reporting Services, the standard reports are generated. For real-time reporting and data analysis, Microsoft SQL Server Reporting Services is used in 70 percent of our company, specifically in the collection and credit departments. The manager wants to separately analyze and freely move the data source so as to be able to find the solutions and ideas during the time owing to which they are not comfortable with Microsoft SQL Server Reporting Services. My company's managers want a good interface like the one provided by Cognos Dynamic Cubes, and because of this, I think my company plans to move to IBM Cognos Analytics in the future. On the reporting part, the dashboard attached to the tool's data visualization capability is not very interactive and doesn't offer multiple functionalities. Though I am not sure about the subscription and delivery features in the tool, I know that sending emails and reports is a good part of the product. There is a separate set of people mainly handling the migration activities of reports. One person is enough to maintain the tool. It is not easy to integrate the product with other tools in the market. Microsoft SQL Server Reporting Services integrates well with Microsoft tools. I have tried to integrate Microsoft SQL Server Reporting Services with IBM Cognos TM1. I saw that fetching data was possible when moving to Cognos Dynamic Cubes, but I saw that some data sources, by default, show zero to all the dimension values, which is why my company had to use filters to remove the zeros. The aforementioned compatibility issues are present in the product. Before choosing a product, people should have knowledge of reporting. People can use the product for standard reports but not for the analytics part. I rate the tool a six out of ten.
I would rate it an eight out of ten. Microsoft also has another solution called Power BI. Power BI is a bit more powerful, and it has more integration compared to Microsoft SQL. So, if organizations are considering using SQL Reporting Services, then it is also wise to do a comparison between Reporting Services and the newer Microsoft Power BI solution.
I rate Microsoft SQL Server Reporting Services an eight out of ten.
Overall, I would rate the solution a 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.
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.
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.
I would rate the product a seven out of ten.
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.
I would recommend the solution to others. Overall, I rate the product a ten out of ten.
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.
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.