Hi all,
I am using SQL Report Builder 3.0. I have an archived database on SQL
2005 and a live, production database on SQL 2008 (different physical
servers.) I'd like to create a single report that allows the user to
switch between both of these data sources depending on the data they
wish to retrieve. So I need something like a checkbox that says
"Select From Archive Data" and will tell the embedded query to select
from the "Archive" data source or else it should use the default
"Production" data source.

Does anyone know how to do that?

Thanks,
Josh