• Repost - originally posted 07-11-2012

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.

6 views0 comments

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t