I started off writing a post on a rather powerful functionality provided in SQL Reporting Services called Data Driven Subscriptions, but then decided to expand it to include a tutorial on how to create Configuration Manager 2007 reports using SQL Reporting Services 2008 Report Builder 2.0. The report we create in this tutorial forms the basis for creating a data driven subscription which will be described in Part 2 of this post. This post attempts to highlight some of the powerful authoring functionalities in Report Builder 2.0 and how it can be leveraged to author Configuration Manager reports.
I have included the tutorial portion of this post as an attachment since it carries quite a few illustrative screenshots which would potentially make this post a bit too long. Please click the
attachments link below to read the remainder of this post and let me know your comments and queries. Also stay tuned for Part 2 of this series since it explores another neat functionality offered by SQL Reporting Services - Data driven subscriptions.