Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 RS 2005 vs. Cognos - Client Installs

Author  Topic 

bassist695
Starting Member

9 Posts

Posted - 2006-01-25 : 15:58:15
We're currently evaluating Reporting Services 2005 vs. Cognos ReportNet.

One issue that's coming up are the software requirements for general users to use the Report Builder feature.

Cognos is a zero-client install product. RS 2005, on the other hand, requires the following of users:
+ .Net Framework 2.0
+ Report Builder installation
+ Report Model updates

This causes a problem at our organization because most of the business users' machines are locked down, meaning they don't have administrator access. They do not have the rights to install model updates, or any other software, without special requests.

If anyone could help me understand the reasoning behind these installs, I would appreciate it.

Thanks,
Mike

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2006-01-26 : 11:03:34
I believe you need .NET Framework IF the application is written in C# or C++.
I presume Cognos is Java-based s/w running as an ASP service?

Looks like you are hitting the difference between fat+thin clients....different underlying technologies in the suppliers software coming to fruition in the client experience.
Go to Top of Page

jhermiz

3564 Posts

Posted - 2006-01-27 : 00:06:39
quote:
Originally posted by AndrewMurphy

I believe you need .NET Framework IF the application is written in C# or C++.
I presume Cognos is Java-based s/w running as an ASP service?

Looks like you are hitting the difference between fat+thin clients....different underlying technologies in the suppliers software coming to fruition in the client experience.



Well you need the .net framework because RS uses that framework for specific assemblies, dll's, and function calls. I'd be careful with Cognos ReportNet. It may be a good product but when you start mixing vs.net projects, a ms 2k / 2005 sql database, and a 3rd party reporting tool you're asking for trouble. A lot of times your reporting application will need to take into account many of the .net functions and properties that are available to the .net framework. If you go with Cognos you lose that functionality. Also does Cognos allow for network sharing of reports and email subscriptions? Is it XML based like RS ?

The cost of RS is cheap if you want to place it on the SQL Server box (although not a recommended practice, but if you're a small shop then why not). I'd definately stick with RS...help you sleep better when you know integration into your current vs.net project is available.

Jon



Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page
   

- Advertisement -