HI
I want to create a report template in SQL Server 2005 Reporting Services.
The template will have a fixed header and footer.I want to use this template in all my reports.
How to do so?
Its very simple. Just design the report header and footer as you want.
Deploy the Report.rdl. Take a copy of this Report.rdl form your working folder and paste it in
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
The path is the place where your vusual studio is installed.
Enjoy...
Hey
Here is step by step tutorial to help you create a basic table report based on theAdventureWorks database using Report Designer.
Tutorial: Creating a Basic Report
Lesson 1: Creating a Report Server Project
Lesson 2: Setting Up Connection Information
Lesson 3: Defining a Query for the Report
Lesson 4: Adding a Table Data Region
Lesson 5: Previewing the Basic Report
Hope this helps.
No comments:
Post a Comment