Hi,
I am a relative newbie to VS, so forgive me if this is a dumb question!
We are using VS to deploy reports to Reporting Services 2005, into at least two environments (Test / Prod).
The issue is that due to the testing required, and depending on what is being tested, the datasources need to sometimes be different between the environments (e.g. there is a datasource for the test environment that points to a custom version of one of our production systems). When these reports are deployed to production, they always point to the same database.
When the report is deployed is always deploys ALL of the datasources associated with the project. This means that we end up with all of the test datasources being created in the production environment all of the time.
Is there a way to make VS only deploy the datasource which the report is actually using? Or alternatively a way to associate particular datasources with a specific environment (e.g. if 'Test' is selected, deploy all datasources, if 'Live' is selected, only deploy certain datasources).
Thanks for any help!
Regards,
Mark