SQL Server Reporting Services help needed!

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

SQL Server Reporting Services help needed!

Author

Topic

salmanshehbaz
Starting Member

3 Posts

Posted - 2007-03-14 : 09:08:32

Hi Gurus
Currently we are using SQL Server Reporting Services on top of our client data warehouse. Almost all the reports deployed on the report production server are executing Stored Procedures (behind the scene).
Can anyone tell me how can I query Report Server database to get a list of reports and the stored procedures being executed by these reports?

Early Thanks,
Salman Shehbaz.
Database Administrator
Xavor Corp.
92-321-440-0797

jhermiz

3564 Posts

Posted - 2007-03-15 : 08:38:09

Take a gander here: http://jhermiz.googlepages.com/powerofreportserver

To get a listing of reports try the following:


USE ReportServer
GO
SELECT rc.Name, rc.Description 
FROM ReportServer.Catalog rc
WHERE rc.Type=2  --rc.Type=2 means give me the low level reports and not the high level folder where the reports sit
GO

Programmers HowTo's -- [url]http://jhermiz.googlepages.com[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources