Barring a TSQL solution, I have done this in the past with a scripting object that calls to the report server via URL.

THIS[/url] link provides a good overview of a fully parameterized solution, and will give you an idea of what to investigate if you have more specialized needs.

Good luck!

EJM