Reporting Services template

When you start creating a large number of reports, you need to ensure the consistency in the look and feel of reports. The header and footer of all reports should have the same information, use the same colour and logos across all reports in a consistent manner. By using a Reporting Services template you can ensure a report layout that is consistent. Creating a report template is the same as creating a new report; the only difference is where you place the report template. You need to place it in the right location, so that it appears as a report template when creating a new report in the New Item/Report dialog box. 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.

This is the same location structure for later versions of SQL Server and VS and is dependent upon the installation path of VS.

You can obviously create multiple templates for different purposes.