This course is designed to teach the advanced functionality, report server administration and security issues of SQL Server Reporting Services. Course topics include advanced report design, integrating parameters and filters, implementing interactive reporting features, scheduling automated delivery of reports, securing Reporting Services, optimizing report performance, implementing strategies for business and support systems, and rendering reports using .NET code.  

• T-SQL Programming or equivalent knowledge required 

Session 1

Introduction to SSRS 
Chapters 1–5 

• Report Authoring and Server Architecture  
• Database Basics  
• Installing Reporting Services  
• Exploring Reporting Services Fundamentals 

Session 2

Developing Reports Part 1 of 6
Chapters 6, 7 

• Planning your report design 
• Working with report server projects 

Session 3

Developing Reports Part 2 of 6 
Chapters 8, 9 

• Retrieving data for a report 
• Designing the report layout  

Session 4

Developing Reports Part 3 of 6 
Chapters 10, 11 

• Working with the tablix  
• Developing Expressions   

Session 5

Developing Reports Part 4 of 6 
Chapters 12, 13 

• Using Functions 
• Adding interactivity 

Session 6

Developing Reports Part 5 of 6 
Chapters 14, 15 

• Creating dynamic reports with parameters  
• Managing the page layout  

Session 7

Developing Reports Part 6 of 6 
Chapter 16 

• Using Analysis Services as a data source 

Session 8

Adding Data Visualization – Part 1 of 2 
Chapters 17, 18 

• Creating Charts  
• Working with Chart Elements  

Session 9

Adding Data Visualization – Part 2 of 2 
Chapters 19, 20 

• Comparing values to goals with gauges 
• Displaying performance with indicators  

Session 10

Managing the Report Server
Chapters 23–25 

• Deploying reports to a server 
• Securing report server content 
• Performing administrative tasks 

Session 11

Viewing reports 
Chapters 26–28

• Accessing reports online 
• Subscriptions 
• Data alerts