55128: Writing Reports with Report Builder and SSRS Level 2 Training

Name: 55128: Writing Reports with Report Builder and SSRS Level 2 Training
Brand: Microtek Learning
Price: $1185
Rating: 4.8 (189 reviews)

Course Description

Students will continue to study the fundamentals of report writing using SSRS and Microsoft® SQL Server® Report Builder in this two-day course. This course focuses on constructing parameter reports, custom reports utilizing the list data region, complicated expressions for formatting and analysis, images and subreports added to reports, drill-down and drill-through features created, and sparklines, data bars, and indicators added to reports. All supported versions of Microsoft SQL Server are compatible with Report Builder, and this course can be used with any of those versions.

Training Exclusives

Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
Access to Microsoft Official Courseware (MOC).
Real-time Virtual Lab Environment.
Experience 24*7 Learner Support.
Self-paced learning and flexible schedules.

Prerequisites for this training

55123: Writing Reports with Report Builder and SSRS Level 1 Training

Who should attend this course?

The majority of this course's audience consists of individuals who are new to creating reports using Microsoft® SQL Server® Report Builder and SSRS, individuals who are switching from another reporting software solution, and individuals who are now Report Builder and SSRS report authors.
People who use Report Designer are the course's secondary audience (SSRS).
Participants in the course may be business analysts, program analysts, data analysts, database administrators, or IT professionals; they may or may not have programming (Visual Basic) and/or Transact-Structured Query Language (T-SQL) experience, as well as knowledge of Microsoft® SQL Server® Report Builder and SSRS.

Microsoft Certified Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

Jun 22, 2023

9:00 am - 5:30 pm EST

Online

ENROLL NOW

Jul 06, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

GTR

Jul 20, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

Aug 03, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

Aug 17, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

GTR

Aug 31, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

GTR

Sep 14, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

Sep 28, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

GTR

Dec 04, 2023

9:00 am - 5:00 pm EST

Online

ENROLL NOW

What you will learn

Construct parameter reports.
Make reports with lists.
Create complex expressions in reports.
Insert pictures and subreports.
Include drill down and drill through capabilities.
Include indicators, data bars, and sparklines.

Curriculum

Module 1: Parameter Reports

This module introduces the use of the parameter in report writing. Parameters allow a level of self-service reporting wherein the report audience can choose the data to view (date range, department, geography, etc.).

Lessons

Parameterized Reporting

Create Report Parameters

Modify Report Parameters

Provide Default Parameter Values

Provide Available Values for Parameters

Lab 1: Creating Parameterized Reports

Create Single Value Parameter Reports

Create Multi-Value Parameter Reports

Create an Available Values Parameter Report

Create a Parameter Report with Default Values

Modify Existing Parameter Reports

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, date range parameters, cascading parameters, provide a list of available parameter values, and provide parameters with default values.

Modify existing parameters and parameter reports.

Module 2: Create Custom Reports with List Data Regions and Master-Detail Data

This module introduces the list data region. List data regions allow report writers free-form control over their reports, whereas, table and matrix reports bind you to a table or matrix data presentation. This free-form feature affords the report writer the ability to truly customize the report.

Lessons

Introducing the List Data Region

Create Reports Using List Data Regions

Modify Reports Which Use List Data Regions

Lab 1: Creating List Reports

Create a Report with Rectangles, Lists, Tables, and Master-Detail Data

Create an Enhanced Report with Rectangles, Lists, Text Boxes, and Tables

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 (master-detail).

Create enhanced reports using list data regions and rectangles.

Module 3: Enhancing Reports with Formatting and Complex Expressions

This module introduces several new report formatting techniques which allow the report writer better control over the data displayed in the report.

Lessons

Enhancing Report Appearance

Using Running Values to Provide Subtotals and Totals

Creating and Using Top N Reports

Lab 1: Enhancing Reports with Complex Expressions

Analyze Report Data with Conditional Formatting

Use Complex Expressions in Charts

Calculate a Running Value

Create TOP N Reports

Format a Table with Alternate Row shading

Formatting a Matrix Report Alternate Row Shading with Visual Basic

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

In this module, students will add images and reports (subreports) to reports, tour and students will be introduced to SSRS (SQL Server Reporting Services).

Lessons

Add Images to Reports

Retrieve Images from a Database

Introducing SSRS (SQL Server Reporting Services) Report Server

Add Subreports to Reports

Lab 1: Working with Images and Subreports

Enhancing an Existing Report with Images

Adding Subreports to a Report

Add Parameterized 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

This module introduces the ToggleByItem and Action properties to incorporate drilldowns and drillthrough reporting.

Lessons

Add and Configure Drilldown Reporting

Add and Configure Drillthrough Reporting

Lab 1: Add Drilldown and Drillthrough Functionality to Reports

Adding Drilldowns to Control Levels of Detail

Add Drilldown Behavior to a Group

Add Drilldown Behavior to a Group Hierarchy

Analyze Data using Drillthrough Behaviors in a Report

After completing this module, students will be able to:

Describe the key features of drilldowns and drillthroughs in a report.

Add drilldowns to Reports.

Add drillthroughs to Reports.

Add parameterized drillthroughs to Reports.

Module 6: Inline Data Analysis with Sparklines, Data Bars, and Indicators

This module introduces the ability to create and add charts to reports. Whether through wizard or individual effort, chart reports or charts as report components allow us to visualize data with or without the details.

Lessons

Sparklines

Data Bars

Indicators

Lab 1: Adding Sparklines, Data Bars, and Indicators to Reports

Analyze Data with Indicators and Data Bars

Analyze Data with Sparklines

Use Indicators to Analyze Data with a Scorecard

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.

With Microtek Learning, you’ll receive:

Certified Instructor-led training
Industry Best Trainers
Official Training Course Student Handbook
Pre and Post assessments/evaluations
Collaboration with classmates (not available for a self-paced course)
Real-world knowledge activities and scenarios
Exam scheduling support*
Learn and earn program*
Practice Tests
Knowledge acquisition and exam-oriented
Interactive online course.
Support from an approved expert
For Government and Private pricing*

* For more details call: +1-800-961-0337 or Email: info@microteklearning.com

Our Clients

For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.