What is the most elegant way to design reports that can be executed against multiple databases? By multiple databases, I mean that I cannot hard-wire the DataSource into the report because at run-time the user will choose which database to execute the report against. Ideally I would like to avoid having to define one shared data source for each Database choice - we add new databases quite often. I considered writing a data source extension, but this seems like overkill. Has anyone dealt with this kind of reporting setup before? How did/would you tackle it?

Thanks!

Zach