Ramblings from the Creator of WilsonDotNet.com
I absolutely hate the process of writing Crystal Reports but they always look so good when finished and the users/management have no idea how much stress went into them, so they all love Crystal. I'm praying for a quick release of the SQL Server reporting tools.
You should check out Report SharpShooter: http://www.9rays.net/cgi-bin/components.cgi?act=1&cid=93
Crystal Reports: Pros: Reliable Plenty of Features Cons: They will rape you for every penny your organization has and then they'll still demand you buy more licenses. Active Reports: Pros: Dirt Cheap. Cons: Horrificly buggy. Terrible API. Missing a lot of basic features. Very very poor GUI tools. I would kill for a decent alternative to either of them. Summary: You're damned if you do, damned if you don't. Screwed anyway. Why not write your reports in Java using XML and XSL:FO? I would if my employer would let me....
What about: http://www.microsoft.com/sql/evaluation/bi/reportingservices.asp TTFN - Kent
Stay far, far away from using the version of Crystal Reports that ships with Visual Studio .NET. It is very buggy and unreliable. If you are seriously interested in going with Crystal Reports, I definitely recommend looking into version 9.0 which is marginally better. Also, like Bryan Murphy pointed out, be prepared to fork over a fortune to pay for licenses with Crystal. I have had good success with Active Reports, but it is really the lesser of two evils. Also avoid the Component One reporting tool at all costs if performance means anything to you (based on 1.0).
Hi Paul, I second Kent's suggestion, check out the beta of the MS reporting services included in SQL Server. The UI is integrated in VS.NET and it is quite a decent tool!! Best regards, Marc
Hi Marc, You mean MS Reporting Services in Yukon, or it is available for SQL 2K too? Peter
Take a look at WordML. Server-side generation of Word documents is now very well support - even without having Word installed on that machine!
Diogenes Revisited: Looking for an Honest Data Reporting Solution
I'd vote for Active Reports. I worked with their AR2 and .Net version and both won my heart indeed. The only thing I don't like much is the Excel output.
LogiXML .NET and web-based reporting is free now. It is a reporting system (like Crystal) rather than a reporting component (like Active Reports), but cost-wise, it is free for develpment and deployment on sigle-processor servers with a low-cost upgrade to support multi-processor servers. Find more informtion at http://www.FreeReporting.com.
Hi, I tried out LogiXML - I couldn't get a single report to work due to errors. Got a one liner help from their support, which was useless! Crystal Reports - their documentation is non-existent. Their Business model revolves around selling licenses and then getting things working through people trained by them alone! Don't fall into that trap. Active Reports - I've just been experimenting with. Again the bundle looks best of all the three. But then you have got to be careful of the pit falls - the product seems to be maturing .. and documentation is quite buggy and difficult to piece together. But of the three - I would prefer playing with Active Reports!!
I'm not getting Crystal as a productive report tool. I have other users creating excel reports that are developed in short period of time and out perform any Crystal report I've seen. My issue is having to tightly couple report parameters in the report. It would be nice to create a template report and have different version based on different user parameters. The lack of native support of DB2 database is a huge issue in my office.
Wish I knew the answer. I have a product that includes Crystal for .NET, but it is hobbled by CR deployment restrictions. Also developing CR reports is all about knowing workarounds, very non-intuitive. ActiveReports apparently has xcopy deployment (which would be ideal for a product designed to be deployed outside of corporate intranets), uses pure C# coding (again ideal), and seems to get better subjective ratings too from users. Going to give it a try I think.
I use Crystal since vb3 and found at greatly powerfull and without bugs. The only concern now is that they are competing against MS and MS obviously is gonna kill them. Will they outlive version 11?
I am a novice to Active Reports and could not creat cross-tab. Is it their limitation, or my stupidity?
We use Stonefield Query out of Canada...A far superior product when compared to all of the alternatives...SQL Reporting Services is free, but somewhat limited in customization. Active Reports has the worst UI I have used. Crystal Reports is the oldest and should be the most flexible, but they seem to have forgotten the latter part.