Sign in
 
HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog

Set SSRS Data Source Information

 This script is designed for SSRS 2008 R2 in SharePoint 2010 Integrated mode, it will require tweaking for native mode or previous versions.   .   This script will accept a SharePoint Document Library url and set the DataSource url for all the reports in that library.   .

 
 
 
 
 
(2)
Add To Favorites
SharePoint
6/22/2012
E-mail Twitter del.icio.us Digg Facebook
Report Abuse to Microsoft
Sign in to Ask a Question

  • Answer the Question | Hide
    DataSource Change Not Working
    1 Posts | Last Post August 17, 2012
    • Written August 17, 2012 
      Hello Ivan,

We developed one report in development envrionment (SSRS + Sharepoint) using Report Builder 3.0. We saved .rsds and .rdl file in sharepoint library. It works fine in development envrionment. 

We restored development site collection from DEV to Staging and used your script in staging enviornment to change data source but it throwing following exception. 

"http://developmentenv/sites/reports/dashboard reports/abc.rsds" could not found".
Is it at all possible to change report datasource from one evivironment to another? Or am I missing anything?

Thanks in advace.

Regards
Prashant Kurapati