SSRS REPORT 批次下载

先捞出report server所有的报表名称
select * FROM [ReportServer].[dbo].[Catalog]
再把报表串成下载字串
http://192.168.1.1/Reports/Pages/Report.aspx?ItemPath=/folder/reportName&SelectedTabId=PropertiesTab&Export=true&ViewMode=List

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" ' URL
INTO #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即可