Changing Datasets on the fly...

[Peager]

Does anyone have a technique for passing a parameter to a report to cause alternate datasets to be selected? We need to be able to 'switch' between two different but similar databases.

Paul

 

[Jacque]

I think I understand your question, try this.

My parameters are as follows:
Name: Database
Data type: String
Default values: Non-queried <defaultdb>

My Data source is setup with the following in the connection string

="data source=yourdatasourcename; initial catalog=" & Parameters!Database.value


hope this helps.
Jacque