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

Microsoft SQL Server Reporting Services vs Windward Core comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
BI (Business Intelligence) Tools (7th)
Microsoft SQL Server Report...
Ranking in Reporting
6th
Average Rating
7.8
Reviews Sentiment
8.0
Number of Reviews
18
Ranking in other categories
No ranking in other categories
Windward Core
Ranking in Reporting
25th
Average Rating
8.8
Number of Reviews
36
Ranking in other categories
Document Generation Tools (1st)
 

Mindshare comparison

As of November 2024, in the Reporting category, the mindshare of IBM Cognos is 4.4%, down from 6.1% compared to the previous year. The mindshare of Microsoft SQL Server Reporting Services is 3.7%, down from 4.9% compared to the previous year. The mindshare of Windward Core is 0.4%, up from 0.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
Gnanavel-Chakkarapani - PeerSpot reviewer
Offers useful templates but needs to improve the connectivity offered
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.
HM
It has streamlined a lot of our reporting processes
Their PDF needs improvement. We've run into some issues when we tried to generate a Word document. If we try to generate the same document in PDF, sometimes it doesn't look exactly the same. We have gone back to Windward support a couple of times on a few issues, e.g., we had some issues with reports that had barcodes on them. The barcode wasn't displaying properly. It was displaying as a skewed image as opposed to an actual barcode. Therefore, we worked with Windward support, having some daily calls with them. Then, within the next release, they were able to resolve the issue. They even gave us a pre-release, so we could implement it into our code before the actual official release on the website. It would be nice to have some sort of workflow capability within the product. Anytime you generate a document, nine out of ten times there is something which precedes that document, whether it's entering parameters in, e.g., if I'm requesting the status report for a project. The first thing that I usually want from a status perspective is which project is the status report for and which week is it for, as those are some of the things that I have to supply before I can generate a document. From a workflow perspective, it would be nice to say, "This project belongs to this person, and this person is okay with me pulling information out of this document for whatever need I have." From a workflow perspective, I would like a wizard interface that goes step-by-step, like a questionnaire, where there are a bunch of things that you have to answer, "Yes or no," before it knows what to do or how to produce the document. Right now, we write our own custom UI for this.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"A drag-and-drop interface for selecting creating ad hoc reports makes this product very easy to use."
"Cognos is the best application with dashboards,batch reporting, jobs, events and ad-hoc reporting for business users."
"Previously, we were doing static reporting. Management would request a report, and it would take staff a week or more to provide it. With Cognos, we have dynamic reporting, and it has reduced both reporting and decision making times significantly. With the solution's dashboard, the company's management team has updated records at their fingertips. This means that they can directly access the data they need to make decisions."
"The most valuable feature is developing reports from different data sources, making it a reliable data source."
"The initial setup is very straightforward."
"Stability-wise, I rate the solution a ten out of ten."
"The dashboarding offered by this solution is very valuable to us."
"The initial setup was straightforward."
"It is scalable."
"I like Microsoft SQL Server Reporting Services' automated reporting feature."
"It is a stable solution."
"The stability of SSRS has been reliable, with minimal issues encountered during our usage."
"The tool's valuable features are its drill-down feature, graphs, and charts."
"The solution is known for its robust security features."
"The SQL Server Reporting Services makes it very easy to get the data whenever we need it."
"I mainly use the solution for the ease of reporting and for executive dashboards."
"Some of our clients are looking at the nested filtering which is coming out. That's going to be a huge benefit for them because they're going to be able to nest and loop while they're also looking at filtering out certain data elements."
"The most valuable feature is that it provides good, dynamic document-generation performance and the documents are being generated reliably."
"We ended up going with Windward for the level of support we got from them during our proof of concept."
"The ability for users to have design and layout control is very important because it allows them control over the design and layout of their reports, without the help of IT."
"The most valuable features are the ability for it to be integrated into our software solution and the AutoTag tool that allows us to quite quickly create and update the templates themselves."
"For the designer we use AutoTag which is a Microsoft Word plugin. In general, it's easy to use, it doesn't have a very steep learning curve. It's not difficult, for people who know Microsoft Office well, to start using the AutoTag tool... It feels just like you're in a Microsoft Office environment with some extra functionality."
"The design tool, with all of its features and sample output fidelity tests, and being able to work with JSON data and output PDF and HTML, were also both crucial."
"The solution is very flexible, so you can create anything you want. Think of the possibilities you have in Excel or in Word, because these are the two document generators that are used the most. I only use Word, but I can use nearly every feature in Word, including making charts and tables, and produce those features in Windward, parametrically."
 

Cons

"There are some problems with how Cognos handles huge data sets and when connecting with multiple sources and searching the data."
"The data uploads that we do, such as Excel files, have a lot of restrictions. If we can make it a bit more user-friendly, allowing us to have more flexibility it would be a great help."
"IBM Cognos's error messages seem to be a bit ambiguous. An error will be encountered and a message will be sent out very ambiguous and after investigating the error message it could be any number of issues. There was never a direct answer to the question or a direct answer to the error messages. Sometimes it would be a generic error message for 21 different solutions. It wasn't very specific, which required a lot of digging around and trial and error trying to fix the problem. The messaging in their error messaging is something needing improvement."
"One thing that we really want is the ability to have data portrayed on an image. Cognos is not able to do it at the moment, and that's becoming a requirement from the business side: having an image and then plotting your dataset on top of the image as a map."
"In terms of what could be improved, I would say, monitoring, monitoring, monitoring. Some improvements in monitoring would be helpful. I'd like to see more monitoring of specific reports and fields. The way the auditing is now is very limited, so I'd like to see more of that - of the monitoring."
"There are many problems with the product's stability part, making it an area where improvements are required."
"The AI-based features could be further enhanced by the solution."
"I think the GIS pieces maybe not as good as we would like."
"In this solution, the cost should be reduced for the enterprise edition."
"The product should improve its performance."
"We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."
"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."
"It would be really nice to have better integration between the solution and Power BI."
"It is not easy to integrate the product with other tools in the market."
"The product could be improved by reducing the time it takes to build and deploy reports."
"We encounter some barriers while trying to build a report."
"The reason it took us so long to get the system up and running is that the APIs could be improved a bit. It could be a little bit more interoperable with software, without having to do a lot of the heavy lifting that we had do to get it in."
"There are some Excel formatting things that you lose when you implement a template: some default Excel validation scripts, macros. You could create them in Excel if you were just using Excel, but in creating a template that generates a report, some of those validation things are lost."
"The error reports also need improvement. If you don't key it in right, it's a little hard to find the root cause. It gives you information as much as it can, but it doesn't really hone in and tell you explicitly what you should do to correct the problem."
"It would be nice to have a black-and-white, ideal setup for servers, to maximize capabilities. We went through a lot of scenarios to get something that is scalable. An ideal AWS-package server setup could have saved us a lot of time. But I understand this is very company specific."
"It is software, so there are always times where things don't work. Most of the time issues happen when trying to move to a new version. There might be problems with reports that were created in an older version, so either we have to make a tweak to the templates or we report it to them and get them to make an adjustment to their software."
"They could make the document creation performance faster. I'm not saying it's slow but it takes time to create the PDFs. If they could make it faster, that would be one area for improvement."
"​The tool does not support macOS documents."
"About six months ago, we raised the possibility of improving the way they manage the HTML 5. Sometimes, when you insert a lot of data in the data source, you get an error because it is not managing HTML 5 features well. I believe they have addressed this in later versions of their product."
 

Pricing and Cost Advice

"It is quite pricy. I think Microsoft BI is cheaper. Tableau might also be cheaper, but it also depends on the usage. If you have very many users, Cognos can be a problem. It could be cheaper than Tableau but not for so many users. If you have a few thousand users, Tableau, which is generally quite expensive, can be cheaper than Cognos."
"Pricing should be improved."
"Cognos is super expensive compared to Tableau ($70/month) and Power BI ($20/month) — I think Cognos is roughly $200 a month."
"The pricing of this product is meant for medium to large-scale enterprises."
"It is averagely priced."
"The cost of IBM Cognos it's more or less the same as most of the other solutions on the market. They're very competitive with the rest of the market and it is not the most expensive product."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"I don't know the exact cost, but I believe Cognos is quite expensive, especially when it comes to the support consultants and the procedures that need to be applied."
"The solution is free to use for developers."
"The tool's licensing costs are expensive."
"The pricing is high."
"Value-wise, the solution's pricing is good for the price that we pay."
"The product pricing is reasonable in terms of suitable features for business."
"The price is pretty good."
"The solution is cheaper than its alternatives."
"The solution is expensive."
"​They are fair and flexible. They are willing to work with your current architecture to make sure you have the best deal.​"
"Pricing is a bit higher than normal desktop applications, but it's well worth it. The ROI is simple to understand and the monthly payment for an annual license is affordable and worth it."
"The pricing is fair. The way that they have it priced is the Windward Designer has a price that's associated with it. Then, depending on the number of cores that you're looking for, that is the price that you pay. The more cores that you want, the more expensive it is."
"The cost is reasonable."
"Pricing is something I complain about. Production pricing is okay, but for a testing environment the pricing looks a bit high to me."
"I'm starting to hear clients squeal about the price of their software. The cost of the software has gone up."
"CapEx fits our requirements, OpEx is higher due to the 20% service and maintenance cost, where we normally pay 15%."
"I can't advise anybody about pricing and licensing, but it was competitive. A lot of things we did look at were all volume-based, so it was a case of you buy a license to generate this many reports a year, and that's not something that I'm particularly interested in because it doesn't give you any idea - if we have future growth, or if we have a lean year - for budgeting reasons it's more difficult. With Windward it's a straight out license fee, whether we generate one page or we generate a million, it makes no difference."
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
56%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Financial Services Firm
14%
Government
12%
Computer Software Company
10%
Manufacturing Company
7%
Computer Software Company
17%
Financial Services Firm
15%
Real Estate/Law Firm
10%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik ...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...
What do you like most about Microsoft SQL Server Reporting Services?
I mainly use the solution for the ease of reporting and for executive dashboards.
What is your experience regarding pricing and costs for Microsoft SQL Server Reporting Services?
Microsoft SQL Server Reporting Services should be okay if you're within the budget. We're just using open-source solu...
What needs improvement with Microsoft SQL Server Reporting Services?
QL Server can support the customer language in the long term, so we can use another language to build some components.
Ask a question
Earn 20 points
 

Also Known As

Cognos, Cognos Analytics, IBM Cognos Analytics
SQL Server Reporting Services, Microsoft SSRS, SSRS, MS SQL Server Reporting Services
Windward, Windward Studios
 

Overview

 

Sample Customers

More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
CMS Wire, The New York Times
HAL, Inc., Axe Group, White Clark Group, Blueprint Software, Aspect Security, Nucleus Software, LeBlanc’s Food Stores, South Sound 911, Aegon, Barclays, Fidelity Investments, ArisGlobal LLC, USDA, RepLink, AON Hewitt
Find out what your peers are saying about Microsoft SQL Server Reporting Services vs. Windward Core and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.