SQL SERVER Hosting :: How To Create a Report Template using SQL Server Reporting Services (SSRS)

This article I will explains how to create a Report Template using SQL Server Reporting Services (SSRS).The SQL Server product includes a service called “SQL Server Reporting Services (SSRS)”. SSRS is a full-featured application that provides report design, development, testing and deployment of reports using the Business Intelligence Development Studio (BIDS) developer tool.
When we are creating reports using reporting services for the organization, we need to first decide how the reports look and we need to maintain the consistency in the look and feel of the reports throughout the organization. For example the report header should have a company logo, address and other company related information whereas the footer should have information like page number, report created date and so on information across all the reports in a consistent manner.

ahp banner sql2014-01

SSRS allows us to create custom report templates with a predefined report layout and to use the same custom template every time when creating a new report. It helps us to maintain consistency across the organization level.

Creating a Custom Report Template

A report Template is nothing but a partially completed report (RDL file for server report and RDLC for client report). We can add our own report template in a BIDS report project template items folder. Creating a custom report template is the same as simply creating a report in BIDS.

The following is the procedure to create a custom report template.

Step 1

Create a new report project or open any existing report project using the Business Intelligence Development Studio (BIDS). BIDS is available with SQL Server 2005, 2008 and 2012.
new report project

Step 2

Create new reports by just right-clicking the report folder and add a new item.

new item

report

It creates a new blank report (RDL or RDLC file). Now we can design a template report just as a normal report but without any dataset or data item. Normally the developer adds a header and footer in a report template.

In this example, I have added a header and a footer. We can add a logo, some background image and we can also a common global report variable like Page numbers, total pages and so on.

insert

background image

Step 3

Save this report.

Step 4

Copy this report file (rdl or rdlc) to the Visual Studio project items folder.
The project items folder is different for different versions of SQL Server. The path of the project items folder as below.

  • 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.

ReportProject

How to use a create report template in our project

The process of creating a template is very easy. This template can be used in a way similar to how a normal report is created. Just right-click on the report folder then select Add new –> new item.

In the next screen, we can see how create template as well. Select this template to get the same look and feel as the template.

custom Report

Output

Here we can see the report with header and footer that are already added to the template.

template


Note :
SSRS allows us to create a custom report template with a desired report layout and using this custom template, we can create a new report and maintain consistency in the report look and feel. We can ensure consistent wth the report layout.

Best Recommended SQL SERVER Hosting

ASPHostPortal.com

ASPHostPortal.com is Perfect, suitable SQL SERVER hosting plan. ASPHostPortal  the leading provider of Windows hosting and affordable SQL SERVER Hosting. ASPHostPortal proudly working to help grow the backbone of the Internet, the millions of individuals, families, micro-businesses, small business, and fledgling online businesses. ASPHostPortal has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch, ASPHostPortal guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability.

HostForLIFE.eu

HostForLIFE.eu guarantees 99.9% uptime for their professional SQL SERVER 2014 hosting and actually implements the guarantee in practice. HostForLIFE.eu is the service are excellent and the features of the web hosting plan are even greater than many hosting. HostForLIFE.eu offer IT professionals more advanced features and the latest technology. HostForLIFe Best , Cheap SQL SERVER 2014 Hosting, Relibility, Stability and Performance of  servers remain and TOP priority. Even basic service plans are equipped with standard service level agreements for 99.99% uptime. Advanced options raise the bar to 99.99%. HostForLIFE.eu revolutionized hosting with Plesk Control Panel, a Web-based interface that provides customers with 24×7 access to their server and site configuration tools.

DiscountService.com.au

DiscountService.com.au is The Best and Cheap SQL SERVER Hosting. DiscountService.com.au was established to cater to an under served market in the hosting industry web hosting for customers who want excellent service. DiscountService.com.au guarantees the highest quality product, top security, and unshakeable reliability, carefully chose high-quality servers, networking, and infrastructure equipment to ensure the utmost reliability. DiscountService.com.au has ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2015, .NET 5/ASP.NET 4.5.2, ASP.NET MVC 6.0/5.2, Silverlight 6 and Visual Studio Lightswitch. DiscountService.com.au is devoted to offering the best Windows hosting solution for you.