I am going to advice a customer what reporting solution he should implement in his new system. The system is on a Windows 2003-platform. The data is stored in an Oracle database, but the customer has a licence for SQL Server and hence he can install Reporting Services for free. The customer is going to use Active Directory and has approx. 70 employees.
Could anyone with knowledge on both Crystal Reports and Microsoft Reporting Services write a comparison between these two reporting solutions? Points of interest are:
-security; how is the access to reports handled and how is the security aspect handled?
-development environment; need info on how reports are developed. Does any of these product make it easy for an end user to develop a report himself?
-integration on windows platform; is it possible to integrate Crystal Reports as a web part into Sharepoint?
-client Side; what products are required on the client to be able to view the reports?
-rendering; can both products render the reports to multiple file formats?
-scheduling; is it possible to schedule reports with Crystal Reports?
-delivery; may both products deliver reports as e-mail or to a file share?
What are Crystal Reports strengths vs. Reporting Services and vice versa?
Any pitfalls on any of these products to be aware of?
Anybody knows what improvements can be expected from Reporting Services in the next release?
I would appreciate your help even though you might not answer every single bullet in this question!