where are my reports located?

Last Post 15 Mar 2007 02:38 PM by sqladmin. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sqladmin
New Member
New Member

--
15 Mar 2007 02:38 PM
each time you set-up Reporting Services there
should be a database called very simply ReportServer.

you want to look for a table called: CATALOG

here you can run various queries which will tell you the report name,
source .rdl path and with the right query you can decifer code.

example1:

select [name] as 'Report', [path] as 'RDL Origin', [CreationDate] as 'Creation', [modifieddate] as 'Modified' from catalog where [content] is not null


example2:

select Name,
substring(convert(varchar(max), convert(varbinary(max), content)), --Expression
charindex('<CommandText>', convert(varchar(max), convert(varbinary(max), content))) + 13, --Start Position
charindex('</CommandText>', convert(varchar(max), convert(varbinary(max), content)))
- charindex('<CommandText>', convert(varchar(max), convert(varbinary(max), content))) - 13) --Length
as Command
from Catalog
where content is not null

hope this is useful.


Acceptable Use Policy
---