SSRS

CREATING YOUR OWN REPORT TEMPLATES WHEN USING MICROSOFT SQL SERVER REPORTING SERVICE

Posted on Updated on

Recently I have configured Scale-out deployments for Sql Server Reporting services which are used to increase scalability of report servers to handle more concurrent users and larger report execution loads.

I have created some sample reports and shown to my VP, She told me that she wants the company logo , name and address of company on every report then I have created a customized SSRS template for Organization .

In this post I am going to tell you how to create your own SSRS template for your own organization instead of using predefined template. For example header of all report should be your company logo and footer will be your company address and more info like when the report is run and more. With this, you can ensure consistent report layout across all reports.

Report template is nothing but it’s an .rdl file which has a default location  as

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

For SQL Server 2016 : C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

Creating a Custom Report Template

Here are the steps:

1. Open a new Report Server project in your Business Intelligence Development Studio.

2. go to solution explorer, reports folder, Right click and choose Add –> New Item. Select report -> Add

3. Add the report header / report footer, Page header / Page footer, your logo, some image / color background for the report, common globals like Page numbers/ total pages,userId, parameters etc.

4. Save the report.

5. Now copy the above created RDL file and paste it in the Visual studio project items folder,

In my case the location is C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

Now you can use this template for your further reports

All you need to do is, Add a new item in a similar way (From the solution explorer, reports folder, Right click and choose Add –> New Item.)

Congratulation  , You made it now ..!