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
2a) Drill Down Matrix Summary Report
Drill down table with row and column grouping, aggregation, totals and toggling.
2b) Drill Down Matrix Summary Report - Expanded
Matrix toggled so it is expanded on one of the centuries.
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.
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.
2d) SQL for Drill Through Inner Report
SQL for the Drill Through Inner Report.