Is there any way to create parameterized reports that query the user for the values, or work like some of the built-in reports and accept a URL parameter?
If you have an external reporting tool that can connect to SQL Server as a data source -- something like Crystal Reports, for example -- there's nothing stopping you from using that to create reports that take parameters.