SSRS - CUSTOM TEMPLATE

最新推荐文章于 2023-05-21 01:14:36 发布

最新推荐文章于 2023-05-21 01:14:36 发布 · 150 阅读

本文介绍了如何在不同版本的SQL Server中放置自定义报告模板到正确的位置以便于在新建项目时使用。针对SQL Server 2005、2008及2012分别给出了模板存放的具体路径。

定制报告模版，SSRS比较容易。

需要保存指定路径：

For SQL Server 2005

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

For SQL Server 2008

C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

For SQL Server 2012

C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

If you are not able to track the above location then Click on Start -> All Programs -> Microsoft SQL Server 2008/2008 R2/2012 -> SQL Server Business Intelligence Development Studio (BIDS)/ SQL ServerDATA Tool (SSDT), right click on it and select Properties, it will pop up the Properties window of BIDS or SSDT, in this window, Copy the path value in Target box. Next click on Start -> Run, paste the path here and click Ok to open the containing folder. The path of BIDS or SSDT will end with Common7\IDE folder; now go to PrivateAssembiles -> ProjectItems -> ReportProject and copy the custom report template that we created above.

使用模版：

Once you are done with placing custom report template at the appropriate location it will start showing up as a template on the New Item/Report Dialog box. To see it in action, right click on the Reports node in theSOLUTION Explorer of the Report Project and then click on Add -> New Item