Changing Database Location in Runtime
I have been creating reports using in a test environment and now I am trying to change over to a production environment and eventually to multiple sites. The report datasource is an SQLOLEDB connection. I am able to pass login information now but I am unable to change the datasource location from the test environment to the production environment. Can someone shed some light on how to change the datasource location in the report during runtime.