Module #1: Foundation
  • Foundation #1 – Getting Started
  • Learning Outline
  • Training Slideshow
  • Foundation #2 - Installing Tools
  • Foundation #2a - Installing SQL Server Developer Edition
  • Foundation #2b - Installing SQL Server Management Studio
  • Foundation #2c - Installing Visual Studio for SQL Server Reporting Services
  • Foundation #3 – Installing the Chinook Database
  • Foundation #4 – What’s in the Chinook Database?
  • Foundation #5: SQL Server Reporting Services Components
  • Foundation #6: SQL Server Reporting Services Tools
  • Foundation #7: Getting Help with SQL Server Reporting Services
Module #2: Working with Visual Studio (formerly: Sql Server Data Tools (SSDT))
  • Lesson #1 – Creating a Project in SQL Server Data Tools (SSDT)
  • Lesson #2 – Solutions, Project, and Reports Hierarchy
  • Lesson #3 – Opening a Project in SQL Server Data Tools (SSDT)
Module #3: Creating Reports with the Report Wizard
  • Lesson #4 – Report 1 – Customer Email List
  • Lesson #5 – Report 1b – Customer Email List Modified
  • Lesson #6 – Report 2 – Customer Invoice Total Report
  • Lesson #7 – Report 2b – Customer Invoice Total Report Modified
  • Lesson #8 – Report 3 – Support by Customer City Report
  • Lesson #9 – Report 3b – Support by Customer City with Parameters
  • Lesson #10 – Report Architecture
Module 4: Creating Reports from Scratch
  • Lesson #11 – Report 4 – Sales by City
  • Lesson #12 – Report 4b – Sales by City Modifications
  • Lesson #13 – Report 4c – Sales by City – Properties Window
  • Lesson #14 – Report 4d – Sales by City – Country Parameters
  • Lesson #15 – Report 4e – Sales by City – Display Parameters
  • Lesson #16 – Report 4f – Sales by City – Merge Cells
Module 5 – Charts, Maps, Gauges, and Dashboards
  • Lesson #17 – Report 5 – Sales over Time – Line Chart
  • Lesson #18 – Report 6 – Sales and Invoice over Time Chart
  • Lesson #19 – Report 6b – Sales and Invoice over Time – Secondary Axis
  • Lesson #20 – Report 6c – Sales and Invoice over Time – Calculated Field
  • Lesson #21 – Report 7 – Sales by Genre
  • Lesson #22 – Report 8 – Sales by State
  • Lesson #23 – Report 9 – Management Dashboard – Part 1 – Datasource
  • Lesson #24 – Report 9 – Management Dashboard – Part 2 – Report
Module 6 – The Customer Invoice Report
  • Lesson #25 – Report 10 – Customer Invoice - Part 1 – Datasource
  • Lesson #26 – Report 10 – Customer Invoice – Part 2 – Invoice Line Items
  • Lesson #27 – Report 10 – Customer Invoice – Part 3 – Invoice Header and Bill To
  • Lesson #28 – Report 10 – Customer Invoice – Part 4 – Logo and Border Formatting
  • Lesson #29 – Report 10 – Customer Invoice – Part 5 – Total, Export to PDF, Image
  • Lesson #30 – Report 10b – Customer Invoice Part 6 – Footer, Image, Global Variable
  • Lesson #31 – Deploying Report to the Report Server and Report Manager
Module 7 – Conclusion
  • Lesson #32 – Course Review
  • Lesson #33 – Next Steps – Where do you go from here?