Crystal reports databases

Hi,

I have a few reports built within the .NET IDE. As such they have the database kinda "built in". I have an exact copy of the database that I want to be able to switch to on the fly (from code).

I can switch the report within the environment, but not from code. I have tryed the SetDataSource method, but no matter what I try, the report always pulls from the database that it was created against within the IDE.

Does anyone know how to change the database on the fly? Any help will be greatly appreciated. :)

Thanks.