Hi,
To change data source from test environment into production after test completed...
Select database from menu--> select set datasource location --> select the view from the report click properties.... it tell you where the data come from......below box...choose consistent view from the test environment then click update... it will replace the view from production with the view from test environment.... that the way how to switch data between two database. Hopefully it help.
Std