Try MySite.GetContent() Catch(Useless Info) Finally Site.Close() End Try

The guide to programming and analyzing SQL, .NET, and SAP
posts - 18, comments - 280, trackbacks - 0

My Links

News

Hello World. I'm Jon Hermiz and am a software engineer here in Michigan. Feel free to look around and leave feedback!

Archives

Post Categories

How To Create Templates in Reporting Services 2005

Scenerio

Have you ever had the urge to create many similiar reports in Reporting Services without having to do all the busy touch up work thats involved?  You know what I mean; the constant header information with your company's logo, the footer with a datetime stamp, or the table that you always have to drag and drop into the report.  What about having the ability for a "new report item" to automatically come out adjusted as a landscape type report (11 x 8.5in) without always having to redefine it.

What You've Been Doing All Along

Every morning you come into work, you open your report project and you begin creating a new report.  And in each one of those reports you have to enable the header and footer, place the logos and times stamps, and set the width of the report to be a landscaped version.  You've done this once for every report and it takes you a good 10 minutes.  You've created well over 50 reports, thats 500 minutes, that's more than 8 hours of work!

What You Can Do

Believe it or not you can create a template report and re-use it across your report projects.  A template you say, what's that?  Well think of a template as a starting point on a task, the bare bones is done for you so you can concentrate on the important aspects of the report.  Think of it like CSS formatting on a web page so you can pay more attention to the actual contents of the page rather than what the web page looks like.

Creating A Report Template In VS

  • 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 Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\

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

That's all there is to it.

So simply design the header / footer of your report.  Set the page size you would like and save this .rdl file.  Place the rdl file in the path mentioned above in green.  The next time you want to create one of your standard 50 reports use the template to get the bare bones of your report complete. 

Thanks to Andrew Polter for pointing this tip out!

Print | posted on Tuesday, August 14, 2007 2:42 PM | Filed Under [ Reporting Services ]

Feedback

Gravatar

# re: How To Create Templates in Reporting Services 2008

How To Create Templates in Reporting Services 2008?////

this path C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\
is not found in visual studio 2008?
8/4/2008 8:12 AM | hussein hoteit
Gravatar

# re: How To Create Templates in Reporting Services 2005

Thanks for your tutorial but how can I get the Landscape Template?
11/10/2008 2:12 AM | TOM
Gravatar

# re: How To Create Templates in Reporting Services 2005

1. In the VS IDE where Business Intelligence PRoject has been opened and reports are being added. While working on a particular report. Go to Report - > Properties -> Layout

2. Change Width and Height of Report interchangeably to change report layout from Lanscape to potratie and vice versa.

3. In SQL 2000 the format were visible as Radio selection icons however in 2005 these properties (height and width ) for the report have to be modified to set the landscape format. After Applying the format on one report it can be saved as a template and used thereafter.
11/10/2008 2:39 AM | richa sood
Gravatar

# re: How To Create Templates in Reporting Services 2008

For SSRS 2008 use the Microsoft Visual Studio 9 directory:
C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
3/4/2009 1:41 PM | Emmanuel
Gravatar

# re: How To Create Templates in Reporting Services 2005

Slick! The report template works great! Just as you've documented. Thanks you!

On a somewhat related continuation of this topic.

Can I do something similar to create a datasource template in a different directory? This would allow my Reporting Services newbies to point and click a report template and a datasource template and voila!, instant report.

3/5/2009 10:48 AM | whenindowt
Gravatar

# re: How To Create Templates in Reporting Services 2005

Nice article. Thanks a lot
10/13/2009 9:33 AM | Arunkumar S P
Gravatar

# DAVETİYECİ

güzel davetiye sözleri ve davetiye metinleri
11/3/2009 9:02 AM | DAVETİYE
Gravatar

# DAVETİYECİ

GÜZEL DAVETİYE SÖZKERİ VE DAVETİYE METİNLERİ
11/4/2009 8:26 AM | davetiye
Gravatar

# davetiye,davetiye sözleri

düğün davetiyesi ve davetiye modelleri
11/20/2009 6:05 AM | davetiyeci
Gravatar

# re: How To Create Templates in Reporting Services 2005

Very Nice article and useful information shared.

Thank you so much

-Prema
3/19/2010 6:34 AM | Prema Tiwari
Gravatar

# re: How To Create Templates in Reporting Services 2005

Yeah, but what if our template changes? We must change every report based on this "template", because it is only one-time copied to report
4/7/2010 10:07 AM | michlimes
Gravatar

# re: How To Create Templates in Reporting Services 2005

michlimes - That is why you want to make sure your template is a good basis for all your reports.
The template does not serve to sync all reports that use it, it is simply a basis to any report that is created.
The same is true with Object Oriented Programming. You want to ensure your base class has little to no changes
once you release it for clients to extend.
4/7/2010 10:11 AM | Jon H
Gravatar

# re: How To Create Templates in Reporting Services 2005

Thanks for the info, this is very helpful. I find that the report wizard does a lot of the work for me in many reports, but the wizard does not appear to use the template. Do you know if there is a way to make the wizard use the template so I can have the best of both?
Thanks,
Leon
4/7/2010 6:49 PM | Leon F
Gravatar

# re: How To Create Templates in Reporting Services 2005

Think of it like CSS formatting on a web page so you can pay more attention to the actual contents of the page rather than what the web page looks like.

snow boots for women | columbia sportswear outlet | cheap mac makeup | the north face jackets

womens snow boots | columbia sportswear | cheap makeup | cheap north face jackets
10/21/2010 5:39 PM | columbia jackets
Gravatar

# re: How To Create Templates in Reporting Services 2005

this is the one of practical interview Question...!
10/31/2010 9:47 AM | ramesh nagineni
Gravatar

# re: How To Create Templates in Reporting Services 2005

Well, like someone else said, it's nice until you want to change it.
And no, it isn't like OOP and the base class because you can change the base class and all derived classes are up-to-date.

Is there a real templating system yet?

Thanks!

Brandon
11/1/2010 3:21 PM | Brandon
Gravatar

# re: How To Create Templates in Reporting Services 2005

You misspelled the word "Scenerao"
2/14/2011 4:50 PM | name
Gravatar

# re: How To Create Templates in Reporting Services 2005

Oops, Scenario
2/14/2011 4:51 PM | name
Gravatar

# re: How To Create Templates in Reporting Services 2005

How To Create Templates in Reporting Services 2008?////

hey i saved the rdl file in the following path C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\
but still template is created
8/10/2011 4:54 AM | Tc
Gravatar

# re: How To Create Templates in Reporting Services 2005

How To Create Templates in Reporting Services 2008?////

hey i saved the rdl file in the following path C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\
but still template is NOT created
8/10/2011 4:55 AM | Tc
Gravatar

# re: How To Create Templates in Reporting Services 2005

Even for me that did not work. However when I placed that into below it worked. It was just a matter of finding the right installatioin path. I find this blog of great help.
C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
11/21/2011 11:03 AM | AjayMalloc
Gravatar

# re: How To Create Templates in Reporting Services 2005

Great article!! Thanks for information
3/6/2012 10:20 AM | organizadores bodas
Gravatar

# No C Drive Access

Thanks for the info. None of our report writers have access to their C drives. Do you know of anyway to set a shared network drive to be the template location for collaborative working?

3/8/2012 9:15 AM | Rob M
Gravatar

# re: How To Create Templates in Reporting Services 2005

I'm also wondering if there is a way to make changes in a lot of similar reports at once. I'm working with 10+ similar reports and it's quite frustrating to go through them all just to make a slight change.

Any info on this is greatly appreciated!
7/27/2012 8:00 AM | G
Gravatar

# re: How To Create Templates in Reporting Services 2005

We must change every report based on this "template",i need help
8/6/2012 4:23 PM | usman
Gravatar

# re: How To Create Templates in Reporting Services 2005

Added rdl file to the path specified:
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\

Still does not show up under templates when creating a new BI/Report Server Project.

VS 2005 version 8.0.50727.762 (SP.050727-7600).

Is there something else that has to be done to have the .rdl file appear as a usable template?
8/21/2012 2:25 PM | Steve
Gravatar

# re: How To Create Templates in Reporting Services 2005

Whoops, never mind. I misunderstood where the actual file would show up.

It appears when you select add new item to your report project, not as a template when you are creating the project itself.

Was thinking it was somehow a project template, not a report template......duh.

8/21/2012 2:35 PM | Steve
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET