List Of Reports

I have created an application that uses reports published via SQL reporting services. I have a form with a report viewer control on it and above that I have a drop down list box. I want to fill the list box with available reports from the server and allow the user to select the report they wish to see. The report list could change so I don't want to hard code any report names in the list The problem I am having is that I can't figure out how to get a list of available reports from the server.

Thanks for any help offered.

Check out this article:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listchildren.aspx

BobP

|||

You may have to alter this for your system but you can try the query below.

selectdistinctnamefrom dbo.Catalog

where policyroot = 0

andpathnotlike'/Data Source%'

andpathnotlike'/Model%'

orderbyname

|||

Thanks to both of you, now I have options because I used both and they work (with slight modifications).

I modified the query as follows and it gives me just the reports

selectdistinctnamefrom dbo.Catalog

where policyroot = 0

andtype= 2

orderbyname

I just didn't realize it was in the Catalog table, I swore I looked but I guess not.

Thanks again