Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What has .Render() on SSRS2000 WebService been replaced with on SSRS2008?

We've recently upgraded one of our SSRS2005 servers to SSRS2008 and have found that all of our applications that utilized the reporting services web service for producing reports no longer works.

The first issue is that the web service itself was no longer available at ReportService.asmx, and had been replaced by: ReportService2005.asmx.

We changed our web reference to the new location and we are now getting the message that the .Render() method is not a part of ReportService2005.asmx. What has the following code implementation been replaced with in SSRS2008?

report = rpt.Render(ReportPath + ReportName, this.Format.ToString(), null, devInfo.ToString(), parameters, null, null, out encoding, out mimetype, out parametersUsed, out warnings, out streamids);

EDIT
After doing some more research, it turns out that the ReportService.asmx was part of SQL 2000 Reporting Services which has now been deprecated out of SQL 2008 Reporting Services.

like image 543
RSolberg Avatar asked May 14 '09 23:05

RSolberg


3 Answers

Here are a couple of articles on migrating from SSRS 2005 to SSRS 2008

  • Upgrading Reports
  • Reporting Services Backward Compatibility
  • Report Server Web Service Endpoints
like image 158
Jon Erickson Avatar answered Oct 30 '22 16:10

Jon Erickson


ReportService.asmx is deprecated. It has been replaced with:

  • ReportService2005.asmx - the management endpoint
  • ReportExecution2005.asmx - the execution endpoint

There is also a SharePoint proxy endpoint. Here's an article enumerating the Report Server Web Service Endpoints for 2008.

like image 34
Greg Avatar answered Oct 30 '22 16:10

Greg


Since ReportService.asmx was removed, as you note, you should use ReportExecution2005.asmx and then change the report parameters as required in your code.

like image 27
jlembke Avatar answered Oct 30 '22 15:10

jlembke