Syndication

News

    I hear that the SQLBits registration is filling up very quickly. SQLBits is a fantastic conference and I would very much recommend it. Register now at www.sqlbits.com before it is too late.
Creating a Report Template in SSRS 2000/2005/2008

If the reports that you create for your organisation contains common items, perhaps images such as company logos, or report properties such as language or pagination settings. You can create a report template that can then be called from within Business Intelligence Development Studio (BIDS)

 1. Create a Project and Report within BIDS.....make a note of the project location for your BIDS project

 2. Add the components to the report that you want to include in the report template, then save the report, close down BIDS

 3. In Windows Explorer, browse to the project folder and copy the report

 4. Paste the report to the following location

     C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ReportProjects

To use the template you have created

 1. Create a Project within BIDS

 2. Right Click the Report folder, point to Add and then click on New item

 3. Within the Add New Item dialogue box, your report template appears, select the template and define a name in the name text

You report template is added to the report with the objects presented that you added when you created the report

 

Published 16 December 2009 22:14 by Testas

Comments

# Creating a Report Template in SSRS 2000/2005/2008 - Chris Testa-O … Report Me@ 19 December 2009 02:43

Pingback from  Creating a Report Template in SSRS 2000/2005/2008 - Chris Testa-O … Report Me