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 ?