There are several options that I have used in the past. Microsoft SSRS (or Microsoft Reporting Services) is a reporting service that is an optional feature of SQL server. Crystal Reports is a "standalone" reporting package that you have to buy separately. I'm sure there are others. I do lots of work in both of these packages, but don't really like either one. Using these reporting packages requires you to bend your mind a bit to understand what you have to do to make it do what you want it to do. The Low Down: If you have SQL Server, you already have SSRS. Your best option is to install it (if you haven't already) and start using it. But realize that if you haven't used it before, you will be pretty much lost. Find some tutorials and help on the web ... or hire someone like me
The SSRS is defenitly the right way. With Crystal reports you cannot create reports. Also there is a small Report builder tool in the ssrs Server that can be used by end users. The SSRS is implemented in the bussiness inteligent Studio, also installed with the SQL Server.