You have a bunch of different options here. You could use connection
porfiles, script to change the db url at runtime or swap datasourece or
datasets using scirpt. I am attaching two examples that swap the
datasource or dataset based on a parameter. If you want an example of
change the db url, you can do this in the beforeOpen of a data source like:
On 6/25/2012 9:16 AM, Emiliano Gonzalez wrote:
> For example, I created two data sources in the report, as I can select
> which data source to use based on a parameter received?.
> I have two identical database with different information and different
> location, and I want to use the same report to both database where the
> report chooses where to get the data.