SQL Server Reporting Services - 报表维护工具

时间:2021-07-21 08:08:30

It seems very easy to deploy new reports to a reporting server directly from visual studio, however when these are to be pushed into our web farm (where developers have no access), this either needs to be done manually, report by report, through microsoft's web front end, or into an MSI.

直接从visual studio将新报告部署到报告服务器似乎非常容易,但是当这些报告被推入我们的Web场(开发人员无法访问)时,这需要手动完成,报告报告,通过microsoft's网络前端,或进入MSI。

However, from time to time we might want to reconfigure report options on the report server such as, changing the data source for all reports or changing the caching options for them. Rather than create a whole new MSI for each set of changes or do this manually I wondered if anyone knew of any alternative tools that can update multiple reports at a time or even able to deploy the contents of a folder into a folder on the reporting server.

但是,我们可能会不时地在报表服务器上重新配置报表选项,例如,更改所有报表的数据源或更改它们的缓存选项。不是为每组更改创建一个全新的MSI或手动执行此操作,我想知道是否有人知道任何可以一次更新多个报告的替代工具,甚至可以将文件夹的内容部署到报告服务器上的文件夹中。

Cheers, Chris

1 个解决方案

#1


2  

For Administrators, rs.exe, http://technet.microsoft.com/en-us/library/ms162839.aspx , allows remote scripting via VBScript. If it's possible to give SOAP access, you should be able to accomplish all you want and more without resorting to an MSI.

对于管理员,rs.exe,http://technet.microsoft.com/en-us/library/ms162839.aspx,允许通过VBScript进行远程脚本编写。如果可以提供SOAP访问权限,您应该能够完成所需的所有操作,而无需使用MSI。

Thanks, Jamie Microsoft Reporting Services - Developer

谢谢,Jamie Microsoft Reporting Services - 开发人员

#1


2  

For Administrators, rs.exe, http://technet.microsoft.com/en-us/library/ms162839.aspx , allows remote scripting via VBScript. If it's possible to give SOAP access, you should be able to accomplish all you want and more without resorting to an MSI.

对于管理员,rs.exe,http://technet.microsoft.com/en-us/library/ms162839.aspx,允许通过VBScript进行远程脚本编写。如果可以提供SOAP访问权限,您应该能够完成所需的所有操作,而无需使用MSI。

Thanks, Jamie Microsoft Reporting Services - Developer

谢谢,Jamie Microsoft Reporting Services - 开发人员