Hills and Moorlands of the Peak District - Mount Famine, South Head, Kinder Scout and Rushup Edge

Microsoft Reporting Services and SQL Examples

SSRS visualisations of varying types and datasets

1) Multi Series Chart - Two Axis
Column chart and a line graph report displaying 3 data series

May 2018 - High Peak Temperature and Rainfall in SSRS

2a) Drill Down Matrix Summary Report
Drill down table with row and column grouping, aggregation, totals and toggling.

Drill Down Table Summary Report in SSRS

2b) Drill Down Matrix Summary Report - Expanded
Matrix toggled so it is expanded on one of the centuries.

Drill Down Table Summary Report in SSRS, toggled

2c) SQL for Drill Down Matrix Summary Report
Report TSQL for the stored procedure containing a CTE (common table expression), derived queries, aggregation and ranking functions.

SQL for Drill Down Table Summary Report

2d) Drill Through Inner Report
The action initiated from a click on a summary report cell displays the inner detail report for the chosen Year and Month. Five years of data are displayed both preceding and following the chosen year. Averages for the month are displayed in a Total column. The inner report is shaded using an expression, resulting in blue background shades for cold and reds for warm temperatures.

Drill Through Inner Report

2d) SQL for Drill Through Inner Report
SQL for the Drill Through Inner Report.

SQL for Drill Through Inner Report