views:

120

answers:

2

In one of the enterprise-level projects, we are using ASP.Net MVC for the web application portion. The reporting system is a huge system with hundreds of reports plus adhoc reporting, printing and notifications, the whole nine yards.

Although we are using MVC for the web portion, the reporting doesn't need to be in the same technology, it's an enterprise software and it can be a separate and independent modules/system.

I have considered the following options, but both have pros and cons:

  • Crystal Report & Crystal Enterprise
  • SQL Server Reporting Services 2005

For example, SQL Reporting Services 2005 is powerful when it comes down to predefined and adhoc reporting, but not good enough for printing. Not sure about 2008.

Considering the need, what reporting tool/system do you suggest for an enterprise level .Net based software, and why?

+1  A: 

This related question may or may not help...

http://stackoverflow.com/questions/168427/compare-sql-server-reporting-services-to-crystal-reports

Ben
Thanks for your answer. That's a good comparison between CR and SSRS. More than a comparison, I'm looking for ideas, and probably more discussions to open new horizons and experiences for me. I don't want to limit myself to those two tools.
Amin Emami
I don't really have an answer and you seem to known enough about SSRS to know how it works but I do know the out of the box SSRS webcontrols do not work well with MVC because of the lack of postback support, other than that integration with any application requires a little work. I think "enterprise" probably needs to be defined better. Are you looking for a central and possibly non programmatic way to deal with reporting you can integrate into an enterprise application or you just trying to create really nice reports? If the later i would probably go with something more custom.
JKG
JKG, it's actually more like a central reporting, printing and notification center. The integration with MVC is not a problem, as long as I find a good, robust reporting tool.
Amin Emami
+1  A: 

Hi,

We use EasyQuery.NET (http://devtools.korzh.com/eq/dotnet) for ad-hoc reporting. EasyQuery is not a reporting solution but some kind of user-friendly query builder instead. For most cases it is enough: we just allow our users to query the data they want, then EasyQuery generates SQL, we execute it and show the result in some grid.

George
I just tried the tool. Not sure if I want to use it in an large application.
Amin Emami