SSRS REPORT 下载 & 怎么捞出report server所有的报表名称?

下载的方式
http://192.168.1.1/Reports/Pages/Report.aspx?ItemPath=/folder/reportName&SelectedTabId=PropertiesTab&Export=true&ViewMode=List

怎么捞出report server所有的报表名称?
select * FROM [ReportServer].[dbo].[Catalog]

把报表串成下载字串

DROP TABLE #TMP SELECT row_number() OVER(ORDER BY  NAME ) As Seq, Type x,*,NAME, 'START chrome.exe "http://192.168.1.123/Reports/Pages/Report.aspx?ItemPath='+Path+'&SelectedTabId=PropertiesTab&Export=true&ViewMode=List" ' URLINTO #TMP   FROM [ReportServer].[dbo].[Catalog]  WHERE 1=1 AND PATH LIKE '/folder/%'    AND Type not in (5,3,4)    order by Type desc    SELECT URL,* FROM #TMP  WHERE Seq BETWEEN 1 AND 300  SELECT URL,* FROM #TMP  WHERE Seq BETWEEN 301 AND 600  SELECT URL,* FROM #TMP  WHERE Seq BETWEEN 601 AND 900

然后把URL弄到bat去,执行bat即可