Report Builder is present in SQL Server 2008 and sounds like the best choice for your requirement. If you are building a custom reporting environment, there is a component you can use to place Report Builder in an ASP.Net web app. Here is a link to get started: