Try our new research platform with insights from 80,000+ expert users

Microsoft SQL Server Reporting Services pros and cons

Vendor: Microsoft

3.8 out of 5

22 reviews
85% willing to recommend

Pros & Cons summary

Microsoft SQL Server Reporting Services integrates with databases like Oracle and SQL Server for data retrieval, creating quality reports with robust security and ease of setup. Users value its scalability and stable customer support but note issues with flexibility compared to tools like Tableau. Pricing, performance challenges, and technical support need improvement. Its installation is complex due to multiple servers, and integration with Power BI requires external tools for better functionality.

Buyer's Guide

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

Prominent pros & cons

PROS

Microsoft SQL Server Reporting Services offers seamless integration with various databases like Oracle and SQL Server, supporting diverse reporting needs.

It is known for robust security features and reliable stability, enhancing user confidence in data handling and reporting.

The tool supports creating quality, real-time reports with excellent drill-down, graph, and chart features, catering to dynamic reporting requirements.

Installation and configuration are straightforward, allowing users to quickly set up and benefit from its extensive reporting capabilities.

Microsoft SQL Server Reporting Services provides effective automated reporting and valuable customer support, ensuring timely assistance when needed.

CONS

Microsoft SQL Server Reporting Services lacks the flexibility and ease of use found in Tableau, as users often prefer Tableau's drag-and-drop functionality and user-friendly interface.

Technical support and performance need improvement to address issues more promptly and efficiently.

There are challenges involving integration with other tools in the market, and better integration with Power BI would be beneficial.

Users encounter difficulties in building and deploying reports due to complex tuning and configuration processes coupled with the need for manual effort to maintain consistency across environments.

Source code management within Microsoft SQL Server Reporting Services is lacking, prompting users to rely on external tools for version control, which could be greatly improved by integrating these capabilities directly.

Microsoft SQL Server Reporting Services Pros review quotes

Chief Information Officer at Solutions Business Technology

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.

Read full review

JN

Senior Consultant, Enterprise Data Management and Governance at a financial services firm with 501-1,000 employees

Sep 22, 2020

The SQL Server Reporting Services makes it very easy to get the data whenever we need it.

Read full review

Arun Sai Kadiam

Cloud Engineer at SLP TECHNOLOGIES PRIVATE LIMITED

Jun 12, 2023

The solution is known for its robust security features.

Read full review

Microsoft SQL Servering Services

Free Report: Microsoft SQL Server Reporting Services Reviews and More

Learn what your peers think about Microsoft SQL Server Reporting Services. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.

881,082 professionals have used our research since 2012.

BA

Chief Solutions Architect at Shepherd365

Jun 14, 2023

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

Read full review

AM

IT Architect at a computer software company with 1,001-5,000 employees

Jun 28, 2023

We can create quality reports in real time.

Read full review

Principal at RxS LLC

Jul 5, 2023

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

Read full review

CEO /Consultant at Version Two Software Solutions Ltd

Jul 10, 2023

It is a stable solution.

Read full review

Cloud Solutions Manager at Fire Minds

Jul 25, 2023

It is scalable.

Read full review

reviewer1634091

Senior Manager at a consultancy with 10,001+ employees

Aug 8, 2023

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

Read full review

Kapil Dev Khatri

Database administrator at Systems Limited

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.

Read full review

Show 10 more reviews (out of 20)

Microsoft SQL Server Reporting Services Cons review quotes

Chief Information Officer at Solutions Business Technology

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.

Read full review

JN

Senior Consultant, Enterprise Data Management and Governance at a financial services firm with 501-1,000 employees

Sep 22, 2020

Technical support is in minor need of improvement so that they can solve problems in a more timely manner.

Read full review

Arun Sai Kadiam

Cloud Engineer at SLP TECHNOLOGIES PRIVATE LIMITED

Jun 12, 2023

The product should improve its performance.

Read full review

Microsoft SQL Servering Services

Free Report: Microsoft SQL Server Reporting Services Reviews and More

Learn what your peers think about Microsoft SQL Server Reporting Services. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.

881,082 professionals have used our research since 2012.

BA

Chief Solutions Architect at Shepherd365

Jun 14, 2023

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

Read full review

AM

IT Architect at a computer software company with 1,001-5,000 employees

Jun 28, 2023

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

Read full review

Principal at RxS LLC

Jul 5, 2023

There is room for improvement in the pricing model.

Read full review

CEO /Consultant at Version Two Software Solutions Ltd

Jul 10, 2023

We encounter some barriers while trying to build a report.

Read full review

Cloud Solutions Manager at Fire Minds

Jul 25, 2023

The setup is difficult because you have to install different servers.

Read full review

reviewer1634091

Senior Manager at a consultancy with 10,001+ employees

Aug 8, 2023

The solution's interface is old.

Read full review

Kapil Dev Khatri

Database administrator at Systems Limited

Oct 26, 2023

In this solution, the cost should be reduced for the enterprise edition.

Read full review

Show 10 more reviews (out of 20)

Product Categories

Product Categories

Popular Comparisons

Popular Comparisons

Microsoft Power BI vs Microsoft SQL Server Reporting Services

Tableau Enterprise vs Microsoft SQL Server Reporting Services

IBM Cognos vs Microsoft SQL Server Reporting Services

Oracle OBIEE vs Microsoft SQL Server Reporting Services

QlikView vs Microsoft SQL Server Reporting Services

Looker Studio vs Microsoft SQL Server Reporting Services

Pentaho Business Analytics vs Microsoft SQL Server Reporting Services

SAP Crystal Reports vs Microsoft SQL Server Reporting Services

TIBCO Jaspersoft vs Microsoft SQL Server Reporting Services

Entrinsik Informer vs Microsoft SQL Server Reporting Services

Plotly Dash Enterprise vs Microsoft SQL Server Reporting Services

RStudio Connect vs Microsoft SQL Server Reporting Services

Windward Core vs Microsoft SQL Server Reporting Services

Oracle Business Intelligence Discoverer vs Microsoft SQL Server Reporting Services

Syncfusion Report Platform vs Microsoft SQL Server Reporting Services

See all alternatives

Product Categories

Product Categories

Popular Comparisons

Popular Comparisons

Microsoft Power BI vs Microsoft SQL Server Reporting Services

Tableau Enterprise vs Microsoft SQL Server Reporting Services

IBM Cognos vs Microsoft SQL Server Reporting Services

Oracle OBIEE vs Microsoft SQL Server Reporting Services

QlikView vs Microsoft SQL Server Reporting Services

Looker Studio vs Microsoft SQL Server Reporting Services

Pentaho Business Analytics vs Microsoft SQL Server Reporting Services

SAP Crystal Reports vs Microsoft SQL Server Reporting Services

TIBCO Jaspersoft vs Microsoft SQL Server Reporting Services

Entrinsik Informer vs Microsoft SQL Server Reporting Services

Plotly Dash Enterprise vs Microsoft SQL Server Reporting Services

RStudio Connect vs Microsoft SQL Server Reporting Services

Windward Core vs Microsoft SQL Server Reporting Services

Oracle Business Intelligence Discoverer vs Microsoft SQL Server Reporting Services

Syncfusion Report Platform vs Microsoft SQL Server Reporting Services

See all alternatives

Related questions

42

Has anyone found a process to migrate reports in WebFocus to Microsoft SSRS?

59

How does Jaspersoft compare to Tableau?

26

Ad Hoc Reporting: QlikView vs. MainFrame Focus

170

Which reporting tool would you recommend for a finely detailed PDF?

39

What are the best self-service and Excel-like filtering / display tools?

261

Which BI tool has the best reporting capabilities?

17

When evaluating Reporting Software, what aspect do you think is the most important to look for?

16

What reporting tools do you recommend?

130

Why is Reporting important for companies?