Has anyone found a way to have SQL Server Reporting Services dynamically generate reports of SharePoint 2007 lists based on the onscreen filtering/sorting and the underlying SharePoint View (columns, groupings)?

We like the flexibility to give power users a way to set up their own custom views of SharePoint lists but we need to find a way to let them produce reports based on their views.

Unfortunately, our users still have a requirement to generate professional looking paper reports. The print capabilities of IE7, although much improved over IE6, are still not good enough for reports that are sent outside of our company. Specifically missing from IE7 are customization of page headers/footers (for company names/logos); and the abillity to save the configurations done within the IE7 print preview window.