O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a report template

Using a report template is a good thing to practice in SSRS development. If we want to have that consistent look, at least in header and footer, we need to use a template.

  1. Let's create a new report and name it as SSRSBlueprintTemplate.rdl.
  2. Now create an empty report with header and footer. Add the same information and expressions we've added in our previous report:
    Creating a report template
  3. Save the report file (SSRSBlueprintTemplate.rdl) at the location C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject.

We want to make sure that we save the template to this location so that SSDT can detect ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required