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