Thanks for your replay, the whole idea is to refresh all the databases from the production server but locally, so any developer can run the script and refresh their (local)...

I was able to find a solution, is not sharp at all but it worked... The queries below will give you an idea, you will need to change the varible...

also I found this article on msdn, but at the end of the page you can read the one comment from Steve Philip where he states that the report properties...

Hi Natraj;

Thanks for your reply, the way I create the linked report is on SSRS, I go to the folder where the report is located and click the dropdown menu...