We upgraded from sql server 2005 to 2008 R2. Now for reporting service, my c# code calls the ReportService2010 object. However the following methods are missing. Render GetReportDataSources SetReportDataSources Google shows many discussions of this sort without a good solution... Please help. Thanks!

There are two main type of endpoints in the Report Server web service (http://msdn.microsoft.com/en-us/library/ms155398.aspx) one for Management wich is the one that has multiple endpoints like ReportService2005, ReportService2006, ReportService2010 and the execution that only has one endpoint ReportExecution2005. The Render method is part of the execution endpoint, so you need to reference it http://msdn.microsoft.com/en-us/library/reportexecution2005.reportexecutionservice.aspx The methods for ReportDataSources where changed in name to GetItemDatasources http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.getitemdatasources.aspx and SetItemDatasources http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.setitemdatasources.aspx BTW, if you don't want to change your code and only needs that it works for native you can keep using ReportService2005 This posting is provided "AS IS" with no warranties, and confers no rights

Jaime, thanks for the reply! The data source error is indeed gone by changing to ReportSerice2005 or 2010 (rs). But if I have another object ReportExcution2005 (re) to do the render, how is re related to rs? With my old version, I just needed to declare rs, then do rs.Render... Thanks!

ReportService has methods just for management not rendering , so if tou call rs.Render it won't work you need to use the execution endpoint (RE) which only has one version http://msdn.microsoft.com/en-us/library/reportexecution2005.reportexecutionservice.aspx

1. You need to call rs.load before to call render, there is a detailed code example here http://msdn.microsoft.com/en-us/library/reportexecution2005.reportexecutionservice.render.aspx 2. You are right , if the datasource is already set you don't need to specify it again, you can think the datasource as part of the report definition thats the reason it is in the management endpoint and not the execution endpoint Jaime - http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights