Alternatively if data driven subscriptions aren't an option, you could do it via SSIS (bit of a faff to maintain though so would use this as last resort) - have a config table, then a script task running the report. Render as Excel, save in a temporary location, then attach it to an e-mail.

There is probably a better solution though...