To conclude this particular series on using SQL Report Builder from within Configuration Manager 2012, I will show how to create an action inside the dashboard’s summary report, linking it to the Operating System Details report we created in the previous half of this series.

Previous videos for the dashboard part of the series can be found here:

CM 2012 – REPORTING – SUMMARIZING RESULTS WITH COUNT STATEMENTS

CM 2012 – REPORTING – GRAPHICALLY REPRESENTING DATA WITH CHARTS

CM 2012 – REPORTING – USING AND CONFIGURING GUAGES

This video will continue building the dashboard we’ve been working on over the last two videos.  Those demonstrations can be found here:

CM 2012 – REPORTING – SUMMARIZING RESULTS WITH COUNT STATEMENTS

CM 2012 – REPORTING – GRAPHICALLY REPRESENTING DATA WITH CHARTS

This session will concentrate on inserting three-color-range guages into the dashboard and configuring them to represent specific defined values.  Additionally, a new dataset will be created to define the variables being used.

The SQL query used in this video is shown below:

DECLARE @TOTAL INT, @CLIENT INT, @ACTIVE INT

SELECT
@TOTAL = COUNT(*)
FROM
v_R_System

SELECT
@CLIENT = COUNT(*)
FROM
v_R_System
WHERE
v_R_System.Client0 = 1

SELECT
@ACTIVE = COUNT(*)
FROM
v_R_System
WHERE
v_R_System.Active0 = 1

SELECT @TOTAL AS Total, @CLIENT AS Client, @ACTIVE AS Active

In my last video, I showed how to create summarized data using SQL COUNT statements.  You can find that post here:

CM 2012 – REPORTING – SUMMARIZING RESULTS WITH COUNT STATEMENTS

For this demonstration, I will use the same SQL dataset and create a simple chart which shows the same data in chart form.