SQL Server Reporting Services (MA-SSRS)
Request a Quote for this class
At Course Completion
Upon completing this course, students will be able to:
- Use SSRS tools
- Work with solutions and projects
- Design basic reports
- Enhance reports with formatting, images, and charts
- Effectively group and summarize data
- Work with parameterized reports
- Incorporate charts and custom maps
- Work with drillthrough reports
- Manage reports
- Utilize Report Builder
Prerequisites
All attendees must have a general familiarity with databases prior to the class. Working knowledge of Microsoft SQL Server or Microsoft Office applications is beneficial.
Hands-on/Lecture Ratio
This SSRS 2012 training is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.
Course Outline
Lesson 1
SSRS Overview and Tools
- Reporting Services Features
- Tools Available with SQL Server 2012
- SQL Server Documentation
Lesson 2
Working with Solutions and Projects
- Working with SQL Server Data Tools
- Understanding Solutions and Projects
- Working with the Visual Studio Interface
Lab:
Solutions to Exercises
Lesson 3
Creating Basic Reports
- What is a Data Source?
- What is a Dataset?
- Using the Report Wizard
- What is Tablix?
- Creating a Tabular Report
- Creating a List Report
- What is a Matrix?
- Deploying a Project
Lab:
Solutions to Exercies
Lesson 4
Formatting Reports
- Working with Text Boxes
- Rich Text Formatting
- Managing Text Boxes
- Drawing Lines and Boxes
- Images
- Page Headers and Footers
- Adding a Document Map
- Rendering Reports
Lab:
Solutions to Exercises
Lesson 5
Custom Expressions
- Understanding Expressions
- Defining Expressions
- Working with Report Variables
- Understanding Lookup, LookupSet, and Multilookup Functions
- Expression Samples
Lab:
Solutions to Exercises
Lesson 6
Summarizing and Sorting
- Creating Groups
- Parent/Child vs. Adjacent Groupings
- Adding Totals and Aggregations
- Creating Aggregates of Aggregates
Lab:
Solutions to Exercises
Lesson 7
Add Flexibility with Parameters
- Adding Parameters to a Report
- Report Parameters vs. Query Parameters
- Manage Report Parameter Properties
- Use Parameters with SQL Queries and Stored Procedures
- Work with Cascading Parameters
- Sort Based on a Parameter Setting
- Filtered Reports
Lab:
Solutions to Exercises
Lesson 8
Enhanced Report Items
- Charts
- Gauges
- Add a Map to a Report
- Data Bar, Indicator, and Sparkline Report Items
- Nesting Data Regions
- Subreports and Drillthrough Reports
- Working with Drillthrough Reports
Lab:
Solutions to Exercises
Lesson 9
Using Report Manager
- Deployment
- Navigating Report Manager
- Understanding Permissions
- Viewing Reports
- Working with Shared Data Sources
- Managing Reports
Lab:
Solutions to Exercises
Lesson 10
Using Report Builder for SQL Server 2012
- ClickOnce vs. Stand-alone
- Installing the Stand-alone Version
- Using the Report Builder Tool
- Creating Datasets
- Creating Reports
- Creating Reports Using Wizards
- Creating Reports Without a Wizard
- Opening Existing Reports
- Working with Report Parts
Lab:
Solutions to Exercises