Writing Reports with Report Designer and SSRS 2016 Level 2

Session Detail:    Classroom 2 Day

In this 2-day course, students will continue their learning on the foundations of report writing with Microsoft SQL Server Report Designer and SSRS. The focus will be on report creation by connecting to a database and manipulating the data for presentation including creating parameter reports, creating list reports, adding complex expressions to reports, adding images and subreports to reports, adding drill down and drill through functionality, and adding sparklines, data bars, and indicators to reports. Report Designer is available for all supported versions of Microsoft SQL Server.

Prerequisites

  • Familiarity with Windows
  • Creating and navigating folders
  • Opening programs
  • Manipulating windows
  • Copying and pasting objects
  • Formatting text
  • Saving files

Who Can Benefit

The primary audience for this course are persons who are new to reporting with Microsoft SQL Server Report Designer and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors.
The secondary audience for this course are persons who are using Report Builder (SSRS).
Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft SQL Server Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.

Session Outline

Class Outline

Module 1: Parameter Reports

  • Lesson 1: Parameterized Reporting
  • Lesson 2: Create Report Parameters
  • Lesson 3: Modify Report Parameters
  • Lesson 4: Provide Default Parameter Values
  • Lesson 5: Provide Available Values for Parameters

After completing this module, students will be able to:

  • Describe the key benefits and features of report parameters
  • Create parameterized queries and parameterized reports
  • Create parameters which accept single values, multiple values, expose or hide the parameter value, provide a list of available parameter values, and provide parameters with default values
  • Modify existing parameters and parameter reports

Module 2: List Data Regions

  • Lesson 1: Introducing the List Data Region
  • Lesson 2: Create Reports Using List Data Regions
  • Lesson 3: Modify Reports Which Use List Data Regions

After completing this module, students will be able to:

  • Describe the benefits of list data regions and rectangles in reporting scenarios
  • Create reports which display data in multiple columns
  • Create reports which take advantage of nested data
  • Create enhanced reports using list data regions and rectangles

Module 3: Enhancing Reports with Complex Expressions

  • Lesson 1: Formatting Reports
  • Lesson 2: Top N Reports
  • Lesson 3: Running Values

After completing this module, students will be able to:

  • Create conditional formats for data displayed in a report
  • Use complex expressions in charts
  • Calculate running values for groups and datasets
  • Create TOP N reports for groups and datasets
  • Use row banding in a data region

Module 4: Enhance Reports with Images and Subreports

  • Lesson 1: Add Images to Reports
  • Lesson 2: Retrieve Images from a Database
  • Lesson 3: Introducing SSRS (SQL Server Reporting Services) Report Server
  • Lesson 4: Add Subreports to Reports

After completing this module, students will be able to:

  • Describe the available options for adding images to reports
  • Add images to reports
  • Describe the features of SSRS Report Server
  • Add subreports and parameterized subreports to reports

Module 5: Drilldown and Drillthrough Reports

  • Lesson 1: Add and Configure Drilldown Reporting
  • Lesson 2: Add and Configure Drillthrough Reporting

After completing this module, students will be able to:

  • Describe the key features of drill-downs and drill them through in a report.
  • Add drill down to Reports.
  • Add drill throughs to Reports.
  • Add parameterized drill throughs to Reports.

Module 6: Sparklines, Data Bars, and Indicators

  • Lesson 1: Sparklines
  • Lesson 2: Data Bars
  • Lesson 3: Indicators

After completing this module, students will be able to:

  • Describe the key features of incorporating mini-charts and mini-gauges in reports
  • Add and modify sparklines, data bars, and indicators in reports

Need to train your team?

All of our sessions can be customized to meet your team’s specific needs. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Writing Reports with Report Designer and SSRS 2016 Level 2

2 Day
Classroom

$1,090.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now