Accessing ssrs data sources .rsds via c# code

Question

Hi, I have access to list of our saved data source files .rsds.  I am have a custom assembly methods using c# and like to create a method that uses my existing data source files to access our databases. 

My custome assembly .dll file is working very well just want to add another functionality into it.  Is it possible and if so any examples or info that I can start with would be perfect.

thanks

Answer 1

I have found this link but not that clear to me

http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.setdatasourcecontents.aspx

Answer 2

The link that rv7a99cv gave you is exactly what you are looking for. The only thing is that the documentation is sometimes shady for that object. You must use the function GetDataSourceContents(strDataSourceName). It will give you a DataSourceDefinition object.

Inside the said DataSourceDefinition , there is a member ConnectString, CredentialRetrieval and everything you need to connect to your database.

Hope this helps,

Alex

Edit : This implies that your rds are deployed on your server.

Answer 3

Thank you Alex, as I was searching and looking around found another link http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.getdatasourcecontents I think I have to use this one as I have our reporting servicies is on sharepoint. 

I know some how I have to access the http://<Server Name> /_vti_bin/ReportServer/ReportService2010.asmx";

Which in SQL Server 2008R2 the reportService2005.asmx not 2010.  I don't understand the top part (code) of the above url.

Answer 4

The URL is simply

http://<ServerName>/<NameOfWebserviceUrlVirtualDirectory>/ReportingService2010.asmx

The name of <NameOfWebserviceUrlVirtualDirectory> can be found in the Reporting Service Configuration Manager in the Web Service URL Tab.

Edit : I have no clue what the /_vti_bin is and I don't think it is really necessary. Well I never added that in my url and it worked. It might be their Virtual Directory that is set to /_vti_bin/ReportServer

Answer 5

Hi rv7a99cv,

Thanks for your posting.

If you are using SQL Server 2008 R2 Reporting Services, you can use the ReportingService2006.SetDataSourceContents Method or the ReportingService2010.SetDataSourceContents Method. As for the /_vti_bin/ in the URL of the sample, I agree with Alex that it should be the virtual directory.

Regards,
Mike Yin

---

Mike Yin

TechNet Community Support

Answer 6

thank you both, I will try and keep you posted.  Thanks again for your replies.