How to Create the SSRS report Template

How to Create the SSRS report Template 

Introduction  

Generally reports are designed like the report header with the logo one left side and the report name in the right side, and report footer contains the page numbers and the page counts these data are common to all the reports. For Example: - The sample report look like 

Issue:- 

This is the sample template design to work with all the reports. There is time taken process for creating the all these same designs for all the reports 

Overcome:-

To overcome this issue we need to create one report template and use the template for all reports.

Creating the Template report in SSRS

Go to solution explorer – Right click on reports – Add – New Item – Select the report template and name it as CommonReportTemplate -- and design the report as show above.

Now copy the CommonReportTemplate.rdl  and past that file to this location 

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

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

To check the temple add the new template and you will find the other template with name

CommonReportTemplate.rdl  select that report and name it and click on Add .