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

Published Sep 07 2018 06:35 PM 32 Views
Microsoft
First published on CloudBlogs on Mar, 17 2009

[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.

CreatingCM2007ReportsUsingReportBuilder.docx

%3CLINGO-SUB%20id%3D%22lingo-sub-246727%22%20slang%3D%22en-US%22%3ESQL%20Reporting%20Services%20%E2%80%93%20Tools%20and%20Features%20Part%201%3A%20Creating%20Configuration%20Manager%202007%20Reports%20Using%20Report%20Builder%202.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-246727%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20CloudBlogs%20on%20Mar%2C%2017%202009%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3E%3CI%3E%20%5BToday's%20post%20is%20provided%20by%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fconfigmgrteam%2Fpages%2Fbhaskar-krishnan-s-bio.aspx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20Bhaskar%20Krishnan%20%3C%2FA%3E%20%5D%20%3C%2FI%3E%3C%2FP%3E%0A%20%20%3CP%3EI%20started%20off%20writing%20a%20post%20on%20a%20rather%20powerful%20functionality%20provided%20in%20SQL%20Reporting%20Services%26nbsp%3Bcalled%20Data%20Driven%20Subscriptions%2C%20but%20then%20decided%20to%20expand%20it%20to%20include%20a%20tutorial%20on%20how%20to%20create%20Configuration%20Manager%202007%20reports%20using%20SQL%20Reporting%20Services%202008%20Report%20Builder%202.0.%20The%20report%20we%20create%20in%20this%20tutorial%20forms%20the%20basis%20for%20creating%20a%20data%20driven%20subscription%20which%20will%20be%20described%20in%20Part%202%20of%20this%20post.%20This%20post%20attempts%20to%20highlight%20some%20of%20the%20powerful%20authoring%20functionalities%20in%20Report%20Builder%202.0%20and%20how%20it%20can%20be%20leveraged%20to%20author%20Configuration%20Manager%20reports.%3C%2FP%3E%0A%20%20%3CP%3EI%20have%20included%20the%20tutorial%20portion%20of%20this%20post%26nbsp%3Bas%20an%20attachment%20since%20it%20carries%20quite%20a%20few%20illustrative%20screenshots%20which%20would%20potentially%20make%20this%20post%20a%20bit%20too%20long.%20Please%20click%20the%20%3CSTRONG%3E%20CreatingCM2007ReportsUsingReportsBuilder.docx%20%3C%2FSTRONG%3E%20attachments%20link%20below%20to%20read%20the%20remainder%20of%20this%20post%20and%20let%20me%20know%20your%20comments%20and%20queries.%20Also%20stay%20tuned%20for%20Part%202%20of%20this%20series%20since%20it%20explores%20another%20neat%20functionality%20offered%20by%20SQL%20Reporting%20Services%20-%20Data%20driven%20subscriptions.%3C%2FP%3E%0A%20%20%3CP%3E--%20%3CA%20href%3D%22http%3A%2F%2Fblogs.technet.com%2Fconfigmgrteam%2Fpages%2Fbhaskar-krishnan-s-bio.aspx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20Bhaskar%20Krishnan%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CI%3E%20This%20posting%20is%20provided%20%22AS%20IS%22%20with%20no%20warranties%2C%20and%20confers%20no%20rights.%20%3C%2FI%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmsdnshared.blob.core.windows.net%2Fmedia%2FTNBlogsFS%2Fprod.evol.blogs.technet.com%2Ftelligent.evolution.components.attachments%2F01%2F6965%2F00%2F00%2F03%2F21%2F42%2F60%2FCreatingCM2007ReportsUsingReportBuilder.docx%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20CreatingCM2007ReportsUsingReportBuilder.docx%20%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-246727%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20CloudBlogs%20on%20Mar%2C%2017%202009%20%5BToday's%20post%20is%20provided%20by%20Bhaskar%20Krishnan%5D%20I%20started%20off%20writing%20a%20post%20on%20a%20rather%20powerful%20functionality%20provided%20in%20SQL%20Reporting%20Services%26nbsp%3Bcalled%20Data%20Driven%20Subscriptions%2C%20but%20then%20decided%20to%20expand%20it%20to%20include%20a%20tutorial%20on%20how%20to%20create%20Configuration%20Manager%202007%20reports%20using%20SQL%20Reporting%20Services%202008%20Report%20Builder%202.%3C%2FLINGO-TEASER%3E
Version history
Last update:
‎Sep 07 2018 06:35 PM
Updated by: