Deploying SSRS 2005 report programmatically and shared data source
I am trying to use the Reporting Services 2005 Web service to deployany updated report from my development PC to our report server. The reports use a shared data sourcewhich has the same name on the report server as in my development environment.I get the error below which I have seen in a few postings in different forums. The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference) I use the CreateReport() method to create the report but I am not resetting any data source. I did trygetting the shared datasource definition with GetDataSourceContents() and then resetting with SetDataSourceContents(); this did not work either. I have not found any solution that works.All I want to do is something similar to deploying the report(s) within VS 2005 withproperty OverwriteDataSource = false.Has anybody encountered this and found a solution? Thanks
February 18th, 2009 7:39pm

Could you tryGetItemDataSources andSetItemDataSourceson the report?This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
February 20th, 2009 4:10am

Hi, The following example illustrates you how to configure a report with the shared data source. DimrsAsNewReportingService2005() rs.Credentials=System.Net.CredentialCache.DefaultCredentials Dimds(1)AsDataSource ds=rs.GetItemDataSources("/datasource/ds") rs.SetItemDataSources("/reports/myreport",ds) If you have any more questions, please let me know.Thanks. ***Xiao Min Tan***Microsoft Online Community***
February 23rd, 2009 1:28pm

Hi everyone, I am also facing the same isssue. And I have tried what you suggested. But its not working. Can you suggest me some. Thanks in Advance, Siddharth Singh
Free Windows Admin Tool Kit Click here and download it now
May 8th, 2011 12:54pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics