Search this insane blog:

Monday, December 8, 2008

SSRS: What Reports do you have out there?

list all the reports you have on your server:

use ReportServer


select ds.name as datasourcename ,
ct.name as itemname ,
ct.path
from dbo.catalog ct (with nolock)
inner join dbo.datasource ds
on ct.itemid = ds.itemid
where type = 2
order by datasourcename ,
itemname

No comments:

Post a Comment