Liste of report made with ReportBuilder

Hi !

I'm trying to figure out how can i get a list of the reports made with reportbuilder. I have create a folder in ReportManger and all my report are in this folder.
When i create report with ReportDesigner i get a .RDL file, but when i create a report using reportBuilder i can't file the file created. What i want to do is to create in our web application a Web page with a list of report that our client has create using ReportBuilder. I was thinking about doing a loop on the folder for each report File but i can't find those files.

Any idea ?

Thanks!I've found the TABLE Catalog in the report server DB. This table seems to contains a list of all reports. Using this i think i can generate a list of reports. Is there a better to do this ?|||

You should use the ListChildren method on the ReportingService2005 web service endpoint to enumerate the items on the report server. You cannot easily determine whether a report was created by Report Builder using that interface, but one good approximation would be to also call GetItemDataSources and find out if the report has exactly one data source reference, and that reference points to a report model. I'm not sure about performance of this approach if you have a very large number of items on your report sever, however.

Hope that helps!

|||Thanks a lot ! This is exactly what i was searching for.|||

I have another question . I've add a web references for the ReportingService. In my .net code i've done this:

Dim ServerRapport As New ReportingService2005

ServerRapport.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim items As CatalogItem() = Nothing

items = ServerRapport.ListChildren("/", True)

Now i was wondering how can i iterate throught all the children. I only want report that are stored in a specific virtual folder on reportServer. I thought that using the collection CatalogItem() i could iterate but it seems that it's not possible. So how can i iterate throught my report to get the liste of the report in a specific virtual folder ?

Thanks !

|||

Right after posting i found the solution. Since this is a collection all i have to do was to create an objet CatalogItem and then do a FOR EACH. Now it's working and the performance seems not to be a problem. We have over 600 reports and it's working fine!

Thanks again!

|||Hi,
How to get the list of folder from reporting server. I know we can get the list of reports from folder but before i want display a list of folder available to my user.

Is this possible?