Hi All, Do we have an equivalent webservice endpoints we had in ReportExecution2005.asmx in SSRS 2008 R2? If not I know this works with 2008 R2 as well, but ill it be deprecated in future? What other options have we got?Tx, Suman

Hi All, Do we have an equivalent webservice endpoints we had in ReportExecution2005.asmx in SSRS 2008 R2? If not I know ReportExecution2005.asmx works with 2008 R2 as well, but ill it be deprecated in future? What other options have we got?Tx, Suman

This is a duplicate post http://social.msdn.microsoft.com/Forums/en-AU/sqlreportingservices/thread/bbb18001-e563-4244-9525-3a803d6f73b1Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

New Web Service Endpoint The report server includes a new management endpoint named ReportingService2010. This endpoint merges the functionalities of both the ReportingService2005 and ReportingService2006 endpoints, and can support management operations of the report server in both native mode and SharePoint integrated mode. It also includes new features that are introduced in SQL Server 2008 R2, such as shared datasets and cache refresh. For more information, see Report Server Web Service Endpoints. Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker

Hi Jeff, THanks for the response, but can you help me point to the right webservice methods in ReportingService2010? Basically Im looking at rendering the report as byte which we use to do using ReportExecution2005.asmx webservice?Tx, Suman

Hi Suman, The ReportService2010 Web service enables developers to programmatically manage objects on a report server that is configured for either SharePoint integrated mode or native mode. To your requirement, I think you can make use of ReportExecutionService.Render Method to processes a specific report and renders it in the specified format. I give a sample as below, you can get a reference: using System; using System.IO; using System.Web.Services.Protocols; using myNamespace.MyReferenceName; class Sample { static void Main(string[] args) { ReportExecutionService rs = new ReportExecutionService(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; rs.Url = "http://myserver/reportserver/ReportExecution2005.asmx"; // Render arguments byte[] result = null; string reportPath = "/AdventureWorks Sample Reports/Employee Sales Summary"; string format = "MHTML"; string historyID = null; string devInfo = @"<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>"; // Prepare report parameter. ParameterValue[] parameters = new ParameterValue[3]; parameters[0] = new ParameterValue(); parameters[0].Name = "EmpID"; parameters[0].Value = "288"; parameters[1] = new ParameterValue(); parameters[1].Name = "ReportMonth"; parameters[1].Value = "6"; // June parameters[2] = new ParameterValue(); parameters[2].Name = "ReportYear"; parameters[2].Value = "2004"; DataSourceCredentials[] credentials = null; string showHideToggle = null; string encoding; string mimeType; string extension; Warning[] warnings = null; ParameterValue[] reportHistoryParameters = null; string[] streamIDs = null; ExecutionInfo execInfo = new ExecutionInfo(); ExecutionHeader execHeader = new ExecutionHeader(); rs.ExecutionHeaderValue = execHeader; execInfo = rs.LoadReport(reportPath, historyID); rs.SetExecutionParameters(parameters, "en-us"); String SessionId = rs.ExecutionHeaderValue.ExecutionID; Console.WriteLine("SessionID: {0}", rs.ExecutionHeaderValue.ExecutionID); try { result = rs.Render(format, devInfo, out extension, out encoding, out mimeType, out warnings, out streamIDs); execInfo = rs.GetExecutionInfo(); Console.WriteLine("Execution date and time: {0}", execInfo.ExecutionDateTime); } catch (SoapException e) { Console.WriteLine(e.Detail.OuterXml); } // Write the contents of the report to an MHTML file. try { FileStream stream = File.Create("report.mht", result.Length); Console.WriteLine("File created."); stream.Write(result, 0, result.Length); Console.WriteLine("Result written to the file."); stream.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } } } Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

I'm facing the same issue in my project. I know I can do it with ReportExecution2005.asmx endpoint but this will be deprecated, right? Could you provide me an example of the same code but using ReportService2010.asmx instead of ReportExecution2005.asmx? Thanks

The ReportExecution2005.asmx endpoint is not being deprecated, so you can continue using it. The ReportService2005.asmx and ReportService2006.asmx endpoints are being deprecated and replaced by the ReportService2010.asmx endpoint.

Thanks for the response, Tristan, my mistake. I've confused the terms ReportService2005 and ReportExecution2005.