Category Archives: Reporting

CM 2012 – Reporting – Using Actions to Provide for Drill-Downs

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

 

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

CM 2012 – Reporting – Graphically Representing Data with Charts

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.

 

CM 2012 – Reporting – Summarizing Results with COUNT Statements

This will be the second half of the series I’m creating on using SQL Report Builder with Configuration Manager 2012. In this part of the series I will show how to build a dashboard using various features.

This first video will demonstrate how to use a COUNT statement in order to summarize query results.

The SQL query used in this video is shown below

SELECT
Operating_System_Name_and0, COUNT(*) AS Qty

FROM
V_R_System

GROUP BY
Operating_System_Name_and0

CM 2012 – Reporting – Using Status Indicators as Visual Queues

I’m continuing the series on SSRS Reporting within Configuration Manager 2012 and building on the previously create report outlined in

CM 2012 – REPORTING – CREATE A TABLE REPORT USING SSRS

CM 2012 – REPORTING – CREATING MEANINGFUL RESULTS WITH SQL CASE STATEMENTS

CM 2012 – REPORTING – NARROWING RESULTS WITH PARAMETERS

We will add an indicator “light” which has the three conditions of green, yellow, and red, to serve as visual queues so that a person reviewing the report can quickly identify troublesome systems.  This will complete the work on this specific report and it will be used as a drill-down destination for a future exercise.

The SQL query used in this video is shown below:

SELECT
v_R_System.Name0,
V_R_System.Operating_System_Name_and0,
CASE
WHEN v_R_System.Client0=1 THEN ‘YES’
ELSE
‘NO’
END AS Client0,
CASE
WHEN v_R_System.Active0=1 THEN ‘YES’
ELSE
‘NO’
END AS Active0,
CASE
WHEN v_R_System.Client0+v_R_System.Active0 IS NULL THEN 0
ELSE Client0 + Active0
END AS Status

FROM
v_R_System

WHERE
V_R_System.Operating_System_Name_and0 = @OSName

ORDER BY
V_R_System.Operating_System_Name_and0,
v_R_System.Name0