SQL Reporting Service Vs Crystal Report

Question

Hello Guys,

i want to make a website.according to the requirements i have many simple as well as complex reports which may have more column to display sometimes. i haven't worked with the reporting in web.i want to know which is best from both of them according to my requirement.

Answer 1

I would suggest you if you are using SQL server on back end then you must use Sql Server Reporting Services as it will give you best features of availbility , compatibility and flexibility, you can further expand it with sharepoint integration at any time , and can utilize the power pivot by utilizing the same underlying T-sql business logic and much more.

Hope it will help you.

---

------------------ Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Maqbool.

Answer 2

Hi DreamSuccess,

Thanks for your post.
Simply, we can distinguish them from the name literally, SQL Server Reporting services is a services, which enables you to design, deploy, delivery and manage reports, after you design the report you can publish it to report server directly, and then you can use report manager to manage this report and delivery this report to specified users using subscription feature, you can also grant the report access right to the spepcifed user, and then the users can access this report directly through report manager web site.  While the Crystal Report is just a report, you must create a application to as a container to host this report. You can choose to use which one according to your bussiness needs.

Reference materials:
SQL Server Reporting Services http://msdn.microsoft.com/en-us/library/ms159106.aspx
Crystal Reports http://msdn.microsoft.com/en-us/library/bb126227(v=vs.90).aspx

Thanks,
Bill Lu

---

Bill Lu

TechNet Community Support

Answer 3

You may want to look at a product like rePORTAL. It is a complete web portal and distribution solution for both Crystal reports and SQL Server Reporting Services (SSRS), so you can quickly publish and distribute both types of reports on the web without any need for coding or programming. It even includes a scheduling engine.

Answer 4

Hello DreamSuccess,

kindly find the below Links for comparing Crystal Reports and SQL Server Reporting Services:

Crystal Reports vs. Microsoft SQL Server Reporting Services

Compare SQL Server Reporting Services to Crystal Reports