Have Geek Brain

SQL Reporting Services: Find the folder where the report is located.

If I have the name of the report, how can I programmatically get the name of the project / folder that the report is in?

So, for example, if I have a report like this

http://server/Reports/Pages/Report.aspx?ItemPath=/ReportProject1/ReportName

Given ReportName

how can I figure out that the report is in the folder ReportProject1

?

So I suppose there is a function where I can pass the name of its report and get its details, or I can query the report server for a list of its report folders and I can skip them and check how this report is inside

+1


a source to share


2 answers


The data is listed in the catalog table in the reporting services database. So a request like



Select Path, Name 
From reportserver.dbo.catalog 
Where name = 'ReportProject1'
+3


a source


you can also use the reporting api service, you can create a custom application that connects to your report server using the report server web service. This will provide you with a wealth of information to query your setup.



Go to http://technet.microsoft.com/en-us/library/ms155076(SQL.90) .aspx for more information

+1


a source






More articles:


All Articles