SSRS 2008 Web service

Question

I need to get all on-demand reports name from report server

SSRS: Get list of all reports and parameters in a single web service call?

That link specify how to do it in sql server 2005 report server.

I have sql server 2008 i have tried http://10.230.193.131/ReportServer/ReportService2008.asmx?wsdl but it gives "The path of the item 'wsdl' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath) Get Online Help"

But I am able to see http://10.230.193.131/ReportServer/ReportService2010.asmx?wsdl

But I am not able to find the node where i get names of all reports

In short how can i get the name of all reports by consuming a service of SSRS 2008

xm1994 xm1994 · Accepted Answer · 2012-02-06T16:37:36

Did you try using the ListChildren method in the ReportService2010 web service? http://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010.listchildren.aspx

Your question was specific to using the SSRS web service interface, but you could also query the SSRS tables directly in sql:

SELECT 
   [Path]        [ReportPath],
   Name          [ReportName],
   Type          [ReportType],
   [Description] [ReportDescription]
FROM
   dbo.[Catalog]
WHERE
   [Type] = 2   -- 1= Folder, 2= Report

SSRS 2008 Web service

3 Answers