SQL Server Reporting Services (SSRS)
Explore the advanced functionality, report server administration and security issues of SSRS.
SQL Server Reporting Services (SSRS)
Explore the advanced functionality, report server administration and security issues of SSRS.
What you’ll be able to do — competencies
- Install and configure SQL Server Reporting Services (SSRS) 2012
- Connect the Report Designer tool to data sources
- Create an SSRS 2012 report
- Make visual enhancements to an SSRS 2012 report
- Create an interactive report
- Manage the report environment
Course description
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.
Prerequisites
- T-SQL Programming or equivalent knowledge required
Syllabus
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
Next available start dates
We aren’t currently offering this course, but we do update our course offerings on a regular basis. Please check back or browse our catalog for more courses that may be available now.
Interested in custom learning solutions for your team?
Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.
Get started