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. http://www.imranbalouch.com/blog/index.php/2010/04/creating-report-template-in-visual-studio/

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)

Advertisements