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.

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.

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 LuBill Lu TechNet Community Support