Crystal Reports .Net Guidance

Question

We have been using .Net and Visual Studio for the last six years, and early on developed a number of web based reporting applications using the .Net version of Crystal Reports that was bundled with Visual Studio. I'm unimpressed with that product: It seems incredibly difficult and convoluted to use. We had to make security changes, install various extra software, and so on.

Now, we are moving to VS2008 and version 3.5 of the .Net framework, and the time has come to redevelop old applications. Our Crystal .Net developers are long gone and I face a decision: Do we stick with Crystal or move to something else? We have the "full" version of Crystal Reports XI at our disposal.

We produce PDF versions of data extracted from various databases. Some apps use the built-in Report Viewer but this seems redundant with the flexibility of grid views. We still need to produce printable PDFs in the grid or in a downloadable Excel format.

• Is Crystal Reports .Net worth persisting with, or should we work out how to use version XI?
• Alternatively is there a simple and low cost way to generate PDF reports without using Crystal?

Answer 1

I have experience with reporting in CrystalReports (trying lite version bundled with Visual Studio), ActiveReports from DataDynamics (4 years, full version), Reporting from Telerik (trying trial version) and XtraReports from DevExpress (last one year).

I think ( and not only me :) ), the CrystalReports are most uneficient tool ( developer productivity ) from this tools. The DataDynamics are much, much more better, bud is littlebit buggy :(. Last year we decided to change reporting suite - we have choosen a XtraReports ( with source code ), and I'm totaly happy. The price is little, no bugs ( to now :) ), wonderfull support, and ( the most important ) the productivity was grown a lot.

I recomend you DevExpress's or Telerik's reporting tools.

Answer 2

I would recommended i-net Clear Reports (used to be i-net Crystal-Clear). It can read your existing *.rpt files. Has a better and easier-to-use API (which I admit is not saying much...).

Answer 3

Like you, I've had poor experiences with Crystal Reports, and my gut instinct is to post "avoid it at all costs" in all caps with lots of exclamation points. However, I've had my afternoon nap today, so I'll post like a grownup.

If all you're looking to do is pdf-ize (yes, it's a real word, damnit!) then you might look into some of the PDF widgets like ABCPDF and the like. It's relatively easy to pop a well-formatted web page into a PDF document and be done with it.

However, if you need tight report formatting, consider sticking with crystal reports -- you have a big investment and knowledge base in the technology. Or, alternately, you could switch to ActiveReports or SQL Server reporting services.

I guess the cost/benefit analysis is the cost of retraining your dev team, and investing in the new technologies.

Answer 4

Move away from CR: just get a good PDF generator and Excel engine for .NET, and feed those using your own database code. You can use all the powerful .NET features, including LINQ, without having to wrestle with the Crystal Reports runtime and its woefully inadequate documentation and support.