In this post I will outline a very simple approach to creating a report template for your SSRS solution. Getting Started Create a new (or open an existing) reporting solution and add a new report, let’s call it _Template.rdl - this report will form the basis of our template. Open this report and add any standard formatting or style that you want for all future reports. Maybe you have standard header/footers, e.
In this post I’ll outline how I used a project from Codeplex http://unittestssrs.codeplex.com to write tests against SSRS reports. From the description from the project page: Allows testing reports deployed to reporting server 2008R2 or 2012 in Native or SharePoint mode. The tests cases are created in xml file in declarative form. Getting Started 1. Download and extract the latest release from the Codeplex site http://unittestssrs.codeplex.com 2. Open the Settings.xml file, in here you will need to set a few different options: