Data Reporting

Chapter 1: SSRS

• 5.1.1 Overview
• 5.1.2 Lecture Notes
• 5.1.3 Readings
• 5.1.4 Websites
• 5.1.5 Video: Exploring SQL Server Reporting Services Components

Chapter 2: Data Organization and Queries

• 5.2.1 Lecture Notes
• 5.2.2 Readings
• 5.2.3 Optional Review Videos
• 5.2.4 Video: SSRS Development and Production Locations

Chapter 3: Report & Data Structure

• 5.3.1 Lecture Notes
• 5.3.2 Readings
• 5.3.3 Websites
• 5.3.4 Login Error for Galactic Reporting
• 5.3.5 Optional Review Videos
• 5.3.6 Video: Navigating SSDT
• 5.3.7 Video: SSRS Getting Started with a New Project
• 5.3.8 Video: Data Sources and Datasets
• 5.3.9 Video: Database Grouping
• 5.3.10 Video: Database Relationships

Chapter 4: Reports & Queries

• 5.4.1 Lecture Notes
• 5.4.2 Readings
• 5.4.3 Websites
• 5.4.4 Optional Review Videos
• 5.4.5 Video: Table Reports
• 5.4.6 Video: Table Grouping
• 5.4.7 Video: Matrix Reports
• 5.4.8 Video: SSRS - Create a New Data Source
• 5.4.9 Video: Upload a Report to SSRS

Chapter 5: Aggregation

• 5.5.1 Lecture Notes
• 5.5.2 Readings
• 5.5.3 Websites
• 5.5.4 Optional Review Videos
• 5.5.5 Video: Grouping and Having
• 5.5.6 Video: Table Grouping
• 5.5.7 Video: Calculated Fields

Chapter 6: Joins

• 5.6.1 Lecture Notes
• 5.6.2 Readings
• 5.6.3 Optional Review Videos
• 5.6.4 Video: Lists

Chapter 7: Variables and Parameters

• 5.7.1 Lecture Notes
• 5.7.2 Readings
• 5.7.3 Websites
• 5.7.4 Video: SQL Variables
• 5.7.5 Video: Parameters
• 5.7.6 Video: DDL Parameters
• 5.7.7 Video: Null Values in Parameters
• 5.7.8 Video: Cascading Parameters
• 5.7.9 Video: Report Variable and Group Variables

Chapter 8: Stored Procedures

• 5.8.1 Lecture Notes
• 5.8.2 Readings
• 5.8.3 Video: SQL Stored Procedures
• 5.8.4 Video: SQL Stored Procedure Parameters
• 5.8.5 Video: Adding Code to Reports

Chapter 9: Charts and Gauges

• 5.9.1 Lecture Notes
• 5.9.2 Readings
• 5.9.3 Websites
• 5.9.4 Video: Charts
• 5.9.5 Video: Gauges
• 5.9.6 Video: User Experience
• 5.9.7 Video: Usability
• 5.9.8 Video: Accessibility

Chapter 10: Maps

• 5.10.1 Lecture Notes
• 5.10.2 Readings
• 5.10.3 Video: Basic Maps

Chapter 11: Intermediate Reporting

• 5.11.1 Lecture Notes
• 5.11.2 Readings
• 5.11.3 Video: Header Visibility
• 5.11.4 Video: Rows per Page
• 5.11.5 Video: Report Templates

Chapter 12: Advanced Reporting

• 5.12.1 Lecture Notes
• 5.12.2 Readings
• 5.12.3 Video: Subreports
• 5.12.4 Video: Document Maps

Chapter 13: Report Security

• 5.13.1 Lecture Notes
• 5.13.2 Readings
• 5.13.3 Websites

Chapter 14: Report Distribution

• 5.14.1 Lecture Notes
• 5.14.2 Readings

Chapter 15: Best Practices

• 5.15.1 Lecture Notes
• 5.15.2 Readings
• 5.15.3 Websites
• 5.15.4 Final Assessment Example Videos