sql server reporting services: If i am working in debuglocal and want to use one datasource then when i
switch to debug i want to use a diff. datasource, i don't know how to do
this. i have both the datasources set up as shared and i can see them in my
project. but when i want to change configurations, i want the datasource to
change as well so that when i deploy to 2 diff. locations, each one uses the
correct datasource.

how i do it now is i change the datasource of the report, then change the
config of the project, and deploy. There should be an easier way to do this.

thanks to anyone!

When you deploy a report the datasources default to not overwritting the one
on the server. So, except for the initial deploy, once you have the
datasource setup on the server you are deploying to, you never have to touch
it again. Also, lets say you deploy new and the data source you had in your
development environment ends up on the server. You can use the web based
report manager to edit the data source (for instance changing the
credentials). Every time you deploy it tells you it is trying to deploy the
datasource and failing but that it fine, just ignore the error. You can
change the default (don't overwrite) if you want to but I personally think
it is best to leave it the way it is. If you ever want to re-deploy the
datasource then just delete it on the server (via report manager) and then
re-deploy.

Bruce L-C

[quoted text, click to view]