Hi
Open the report then go to Database Menu -Select Set Datasource Location you will see the current connection settings depends which connection you are using like ODBC,OLEDB etc....
below you will find Replace with connection panel create a new connection which connects to your testing enviorment
then highlight the production connection and testing connection by selecting it
then click Update
cheers
Rahul