Martin,

With v8 you can do this from integration level. Simply open the report, change the connection string information and save the report back to disk.

Note that what Michael says is true too and in fact also better. The connection information should be as you have it at design time and then at runtime update it to a new string temporarily