Stephanie, you might want to check out this article: 

Generate Ad-hoc Reports with Microsoft Reporting Services 2005

http://www.devx.com/dbzone/Article/28047#rateThisContentLink