SSRS shared data source


I'm working on reports in my new erp system and have some issue with SSRS and shared data source.
Basically, I have 2 db instances: live and test and report services with separate report set for each DB
I modified some report in test and need move into live. All reports using shared data source.
All what i need is copy report from test into live, no problem with that. Then point copied report to shared data source from live. I don't know how to do that. I'm not sure where I should go to make that change. I'm using SQL 2012.
I red if I modify shared data source I will modify for all related reports not only for this one what I'm working on it right now.
Technically I thought,
I can go to specific report file on reportservices website->Manage-> Data Source->Browse->Point here to new shareddatasource
Question is if I make that change I'm making change only for one report or for all reports ?


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alexandre SimõesManager / Technology SpecialistCommented:
Yep, that's the way to do it.
DataSources and reports are independent, so you have to choose which connection goes on which report.
Of course, like you said, changing the configuration of a connection, all reports that use it will be affected.

So the "trick" is to create one connection per environment and set it to the appropriate reports.
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
if I understood your question you copy report to prod: if the shared data source in test is set with the same name \location as in prod-- > just copy SSRS report to prod will be enough ( you still may need to check report property to make sure all is fine)
however as the main idea:

Q:<Question is if I make that change I'm making change only for one report or for all reports ?>
A: You'll need to adjust this for each report that will use this shared data source:

SSRS 101 – Creating a Shared Data Source

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.