I have a table that can potentially display results from two separate databases. I have 2 datasets which I can use to source the data, one uses a stored procedure and connects via a datasource to db1 and one uses an SQL statement and connects via another datasource to db2. I have a parameter that accepts which database I want to retrieve data from - all I need now is to be able to tell the table to use one of the two datasets.
Anybody come across a similar issue and solved it ?