In Report Designer, the easiest way to do this is to edit the shared data source just before running the report.
In the report manager, you can achieve this by having the same data source pointing to different databases in different folders (for example, one folder for DebugLocal, another for Production), as well as deploying and running the report in the corresponding folder.
source share