Sunday, December 19, 2010

Reusing SSRS Template

In an environment where we need to create lot many reports and all the reports have some common charactersitics, it's good idea to have one base report as template and reuse it for authoring other reports for faster development and most important consistency. Here are the easy steps -

1. Create any base template (RDL file) based on your business need.

2. Copy the RDL file (base template) and paste it in the below location:
C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

3. Right click Reports Folder and click Add->NewItem. You can see the newly added report template there, refer below screen shot:


So simple and yet useful...:)

No comments:

Post a Comment