Problem solve Get help with specific problems with your technologies, process and projects.

Reporting capabilities: Microsoft SQL Server 2005 vs. Cognos ReportNet

Expert advice about business intelligence (BI) reporting capabilties in Microsoft SQL Server and Cognos.

I'm looking for a review of Microsoft SQL Server 2005 reporting services vs. Cognos ReportNet. What are the benefits/disadvantages...

of both? What does one have over the other? Microsoft SQL Server 2005 Reporting Services builds on Reporting Services' introduction in SQL Server 2000. It is a licensed component of SQL Server 2005, so you get it with the SQL Server purchase. You would not use it with any other DBMS. Cognos ReportNet, on the other hand, is compatible with many DBMS and it is separately licensed so would naturally be considered more expensive. Both are more than report design tools of the past and both store report element definitions, provide flexible report security and report distribution options. These specialized reporting tools are better at robust "reporting" than drill-down, ad-hoc query data access tools, which do a fair introductory job at reporting. You probably would make a more holistic architecture decision (Microsoft, non-Microsoft) before making this decision.

This was last published in October 2005

Dig Deeper on CRM and marketing

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.