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