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?

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?

List the folder contents using SQL

Hi all,
I have built a Disaster Recovery Site for my DB.on periodic basis, trn files from production server reach DR server and DR setup will apply them locally.

If the flow is smooth then no issues, if one of the file does not reach DR
the entire setup will halt for the want of the file and I dn't have any means to
know which file is missing.

Both my production and DR site located remotely behind firewalls, i.e i can't
physically access the servers or remotely login to the server.

Can anyone tell me how to see the contents in a folder in the server using
SQL query .

Any help is highly appreciated

Thanks and Regards
Srinivas VaranasiI'd use xp_cmdshell (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp).

-PatP|||use

master..xp_cmdshell 'dir c:\'|||Thanks Pat.|||Harshal, sorry to find "STUPID" as Ur Signature

List of all folder permissions

Is there a way to get a list of all folder permissions per folder? We
are in the process of cleaning up two Reporting Services boxes that
have gotten way out of control, including permissions. Part of this
process is assigning users to roles, rather than individual permissions
on folders. But to do this, I need to see who is assigned to what
folder (and there are many). Any ideas?I think RS Scripter will help you in this.
http://www.sqldbatips.com/samples/code/RSScripter/readme.htm#_introduction
Someone wrote an OLAP documenter as a Word macro. When opening the word doc
you could point it at a server and it would document all the cubes. Same
thing would be nice for RS.
Steve MunLeeuw
"madrigal" <nmadrigal@.att.net> wrote in message
news:1160661235.716193.208570@.i3g2000cwc.googlegroups.com...
> Is there a way to get a list of all folder permissions per folder? We
> are in the process of cleaning up two Reporting Services boxes that
> have gotten way out of control, including permissions. Part of this
> process is assigning users to roles, rather than individual permissions
> on folders. But to do this, I need to see who is assigned to what
> folder (and there are many). Any ideas?
>