SQL Reporting Services – Tools and Features Part 1: Creating Configuration Manager 2007 Reports Using Report Builder 2.0

SQL Reporting Services – Tools and Features Part 1: Creating Configuration Manager 2007 Reports Using Report Builder 2.0

  • Comments 4
  • Likes

[Today's post is provided by Bhaskar Krishnan]

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 CreatingCM2007ReportsUsingReportsBuilder.docx 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.

--Bhaskar Krishnan

This posting is provided "AS IS" with no warranties, and confers no rights.


Attachment: CreatingCM2007ReportsUsingReportBuilder.docx
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • Great and inspirational stuff!

    Thanks for sharing.

    And yes... it looks like a smashingmagazine post.

  • Can this document along with Reprot Builder 2.0 be used against SQL Server 2005 Reporting Services?

    I currently have SQL Server 2005 installed along with the Reporting Services and would like to know if I can leverage the above document.



  • Hi Manoj,

    Report Builder 2.0 was released explicitly with SQL Reporting Services 2008 and offers quite an extensive set of features to achieve parity with the SQL Reporting Services 2008 report schema. Basically with SQL Reporting Services 2008 the report schema is different than the SQL Reporting Services 2005 schema. So you may run into some issues trying to run a report authored in Report Builder 2.0 on SQL Reporting Services 2005. As you would expect SQL Reporting Services 2008 is backward compatible, in that, it can run any report authored using the tools available in SQL Reporting Services 2005. The same limitation exists in our Configuration Manager R2 release as well; basically SQL Server 2008 released a month after the R2 release went out - so we couldnt completely validate running reports authored using Report Builder 2.0 from our R2 administration console but you can run all these reports directly from the SQL Reporting Server.

    Hope the above helps. Let me know if you have any specific questions.



  • Hi Bhaskar

    Is it possible to create multiple charts by just using one grouped field?

    For example a field named ApplicationName. In that field i have about 10 applications. I would like to achieve this if i select 5 applications and then each applicationname will instanly show up in their own chart based on my choice of charts.

    Is that possible with report builder 2.0?

    Thanks in advanced