Creating Report Template in Visual Studio

Note: I have moved to blog at my own domain, so kindly visit this post over there for recent updates or comments.

We have been doing report development using SQL Server 2008 Reporting Services and all of reports normally followed a standard pattern, so I thought to design a report template so that we can have all standards while developing a new report. Following are the steps that I found from net for it:

  • Add a new report to your project
  • Using the report designer place any objects (text boxes, tables, lines, etc) on the report that you want as a template.
  • Give the report a name (anything that you can remember in the future, for instance if you want landscape reports and you create a landscape template you should then call the report LandscapeTemplate.rdl)
  • Save this .rdl file to: C:Program FilesMicrosoft Visual Studio 9.0Common7IDEPrivateAssembliesProjectItemsReportProject

The next time you add a report item you will notice this item in the Templates section.

For older version of SSRS use the Microsoft Visual Studio 8 directory:C:Program FilesMicrosoft Visual Studio 8Common7IDEPrivateAssembliesProjectItemsReportProject

And here you go, ALL IZ WELL… (Y)