We use the solution mainly for the KPIs and dashboards.
The easiest route - we'll conduct a 15 minute phone interview and write up the review for you.
Use our online form to submit your review. It's quick and you can post anonymously.
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.
Negative
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.
The standard reports provided by the product are very useful. While creating templates, like in the case of welcome letters, to help our company deal with its customers, Microsoft SQL Server Reporting Services can be very useful.
In Microsoft SQL Server Reporting Services, not much of the interface part is used. With Microsoft SQL Server Reporting Services, its users face issues with the interface after they use Excel or create Microsoft SSIS Packages. The tool's interface is an area of concern requiring improvement.
There needs to be an improvement in the product's connectivity so that the tool can connect easily with other third-party databases. In the dashboard, drag and drop functionality needs to improve, especially when compared to other tools like IBM Cognos Analytics and Qlik Sense.
Microsoft SQL Server Reporting Services is useful only for standard reports. In IBM Cognos Analytics, query studio can be used by users to drag the data and simply download the reports, so the user doesn't need to have any technical knowledge like developers. Microsoft SQL Server Reporting Services is to be improved to offer features like query Studio, which is provided in IBM Cognos Analytics.
I have been using Microsoft SQL Server Reporting Services for 3 years. My previous company had a partnership with Microsoft.
Though it is a stable product, its functionalities have not improved much.
Scalability is possible for small-scale users of the product and not for enterprise-sized businesses.
Microsoft SQL Server Reporting Services is not widely used by companies since it is a tool that is particularly used in a few departments.
In Microsoft SQL Server Reporting Services, the installation and configuration parts are easy.
I rate the product's installation phase a seven out of ten.
My company plans to move to IBM Cognos for better reports and dashboards.
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.
