I attended the SQL Server Reporting Services event yesterday in San Diego. I hadn't downloaded the beta version of it, so this was my first look at the product. I was impressed with it. But now I have to get IIS and VS .NET installed in order to use it, which is going to be a pain since my MSDN subscription expired (it's being renewed but that'll take a couple of weeks).
As a DBA, you are often asked to query production data because the application doesn't provide what is needed. We plan on using Reporting Services to create a few reports so that the people needing the ad-hoc data no longer have to ask a DBA to retrieve it. I'm sure that my organization will use the tool for other things, but this is what we plan on using it for in the next month or so.
I'm hoping that the tool is as easy to use as it appeared to be in the demonstration.