When we deploy a new app it would generally go through three stages...
Development > Testing > Deployment.
Lets say for argument sake they are three different servers. The current SSRS reports has static connection strings, so when something is moved from Development to Testing the connection strings need to be changed for all 20 reports. The change to the connection string would be the server name each time, is there a way to make this dynamic?