Try our new research platform with insights from 80,000+ expert users
Microsoft SQL Server Reporting Services Logo

Microsoft SQL Server Reporting Services pros and cons

Vendor: Microsoft
3.8 out of 5

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Microsoft SQL Server Reporting Services offers an all-in-one package that simplifies toolset requirements for users.
It excels in robust security and seamless integration, working well with various databases like Oracle.
The automated reporting features and straightforward initial setup enhance user experience.
Quality reports can be created in real time, supporting executive dashboards and extensive data visualizations.
Microsoft SQL Server Reporting Services is easy to use, lightweight, and integrates effectively, offering reliable support and minimal operational issues.

CONS

Microsoft SQL Server Reporting Services lacks the flexibility found in Tableau, making it less user-friendly.
Performance improvements are necessary, especially concerning report scheduling and refresh intervals.
Integration issues exist with external tools and Power BI, complicating the process.
The pricing model of Microsoft SQL Server Reporting Services requires re-evaluation to enhance affordability.
There is a need for integrated source code management and improved scalability and stability within Microsoft SQL Server Reporting Services.
 

Microsoft SQL Server Reporting Services Pros review quotes

MB
Aug 9, 2020
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.
Gnanavel-Chakkarapani - PeerSpot reviewer
Mar 22, 2024
In Microsoft SQL Server Reporting Services, the installation and configuration are easy.
AA
Jan 15, 2024
The initial setup is easy.
Learn what your peers think about Microsoft SQL Server Reporting Services. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
842,592 professionals have used our research since 2012.
Ahmad Jallad - PeerSpot reviewer
Jul 25, 2023
It is scalable.
reviewer2397582 - PeerSpot reviewer
May 13, 2024
The stability of SSRS has been reliable, with minimal issues encountered during our usage.
Sunil_Shah - PeerSpot reviewer
May 3, 2024
Microsoft SQL Server Reporting Services (SSRS) is reliable for management dashboard and reporting purposes. It is helpful for user reporting and administrative tasks, such as monitoring progress. It is easy to use since it is lightweight and integrates well with the SQL Server database, making reporting straightforward. The visualization capabilities enhance our reporting needs with good pagination and KPI features. It integrates well with data servers and workbooks, allowing us to publish reports on mobile applications and tablets easily. Integrating other tools and platforms in our tech ecosystem is generally straightforward. However, if we need to perform something very specialized, we might have to use third-party tools rather than inbuilt options.
Kapil Dev  Khatri - PeerSpot reviewer
Oct 26, 2023
I'm very satisfied with the customer service. And usually, whenever we have any issue or details, we get to the person for the support. I'm really satisfied with the service. Within a few minutes or within a few hours, the support person will be available.
JN
Sep 22, 2020
The SQL Server Reporting Services makes it very easy to get the data whenever we need it.
reviewer2379771 - PeerSpot reviewer
Apr 24, 2024
I mainly use the solution for the ease of reporting and for executive dashboards.
MartinSimons - PeerSpot reviewer
Feb 3, 2025
Microsoft SQL Server Reporting Services has been functional whenever I needed to use it.
 

Microsoft SQL Server Reporting Services Cons review quotes

MB
Aug 9, 2020
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.
Gnanavel-Chakkarapani - PeerSpot reviewer
Mar 22, 2024
It is not easy to integrate the product with other tools in the market.
AA
Jan 15, 2024
Sometimes, we need to make sure that the configuration stays consistent across the reporting instances. They all connect to the same database. So, it shares that same backend, but the reporting services itself can also be configured. On the application level, for reporting level. And it is, based on my own experience, it is a manual effort to make sure that the reporting servers are configured the same across the environment.
Learn what your peers think about Microsoft SQL Server Reporting Services. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
842,592 professionals have used our research since 2012.
Ahmad Jallad - PeerSpot reviewer
Jul 25, 2023
The setup is difficult because you have to install different servers.
reviewer2397582 - PeerSpot reviewer
May 13, 2024
The product could be improved by reducing the time it takes to build and deploy reports.
Sunil_Shah - PeerSpot reviewer
May 3, 2024
The complex tuning for report performance is complicated. There is a lack of native support for source code control. We often need to use separate tools like VS Code or other software to manage version control and changes in the database. It would be beneficial if source code management were integrated directly into SSRS, thus eliminating the need to rely on external tools. While CLI-based operations are exemplary, the trend is towards GUI for a better user experience. Integrating both visualization and source code management within SSRS would simplify the process for users.
Kapil Dev  Khatri - PeerSpot reviewer
Oct 26, 2023
In this solution, the cost should be reduced for the enterprise edition.
JN
Sep 22, 2020
Technical support is in minor need of improvement so that they can solve problems in a more timely manner.
reviewer2379771 - PeerSpot reviewer
Apr 24, 2024
It would be really nice to have better integration between the solution and Power BI.
MartinSimons - PeerSpot reviewer
Feb 3, 2025
There are occasions during maintenance runs when the Check Point monitoring system reports a lot of blocked sessions.