Creating Template Reports in RS 2005 -- sql server reporting services

Chris Conner
11/14/2006 2:14:07 PM

I am tired of creating reports from scratch that contain essentially the
same elements, i.e. page footer with DateTime printed, page numbering, and
headers with report file names, setting the same margins and grid spacing
EACH AND EVERYTIME I write a report.

I want to create a template report that I can select from the Add New Item
report dialog. You can do this in SQL 2000 with RS 2000. You put the RDL
file into the following directory:

C:\Program Files\Microsoft SQL Server\80\Tools\Report
Designer\ProjectItems\ReportProject

But HOW do you do that in SQL 2005 Reporting Services?

I am stumped... :)

The closest I have come to finding it is in this directory:
C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

But I don't think I should be using that folder...

Can any Microsoft Reporting Services Developers answer this question please?

Sincerely,
=-Chris

Chris Conner
11/14/2006 2:40:38 PM

You know, sometimes in frustration solutions come to mind... :)

It occured to me that perhaps I was not looking in the right place, so on a
hunch, I did a search for ReportProjectItems.vsdir in Google and came across
Peter Blackburn's book index. I have a copy of Peter Blackburn's book - and
DOH! It shows me what I need to do to get my report templates to show up in
SQL 2005. If the report items are not listed in this file, they do not show
up, whereas in SQL 2000 Report Designer, they did. I also can see I made a
mistake of adding RDL files to this folder without updating the
ReportProjectItems.vsdir file.

Now I am happy!

=-Chris

[quoted text, click to view]

sql server reporting services : Creating Template Reports in RS 2005