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
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