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

IMO, you should consider other criteria as well such as:

• Cost of the software
• Integration with your .NET applications
• API and Programmatic flexibility (All said and done, there are always the "customizations" and tailoring. For such scenarios , developers eventually fall back on programmatic solutions vs. out of box

Now, in my experience (having used both Crystal Reports and SSRS(2005/2008) , though Crystal Reports does come with a friendly set of API, it fails in many basic criteria and developers end fighting the software. This is I say based on my experience with SSRS where developers are far more comfortable with. For starters, it uses XML extensively and the provision to use custom code assemblies does not harm either.

--I think you would where I am getting at---

"Consider & Evaluate SSRS*. If you are hesitant at first, then do a Proof of Concept and test your requirements. I have a feeling you will be pleased with what you see

1. especially considering your requirement of using PDF format.
2. Developers, especially , MSFT specialists will thank you
3. Leverage the Programmatic rendering of the reports (though it sounds fancy , trust me , its not more than handling an API call

For e.g.: public Byte[] Render ( string Report, string Format, string HistoryID, string DeviceInfo, [Namespace].ParameterValue[] Parameters, [Namespace].DataSourceCredentials[] Credentials, string ShowHideToggle, out string Encoding, out string MimeType, out [Namespace].ParameterValue[] ParametersUsed, out [Namespace].Warning[] Warnings out string[] StreamIds); Member of [Namespace].ReportingService )

--- where Format will be "PDF"

Hope you find this relevant

Answer 2

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 3

I can suggest that the built in Microsoft reporting framework works adequately. You can do local reports or MS SQL server based reports. There is a client control that displays reports and can export to formats such as pdf and Excel. Visual Studio can handle report design for the stack.

As far as if it is better than Crystal Reports, I'd say check it out and see if you like it any better or worse. I've worked with the Microsoft Report Viewer more than Crystal Reports but both seem to be fairly similar. Offhand, Crystal Reports seems to be a more advanced reporting tool but more complicated.

I'm not sure about how to utilize the Microsoft Report Viewer infrastructure outside of Visual Studio. If you are using Visual Studio it should all be available in there and you can follow the online help instructions for deploying the pieces for your servers to your servers.