Consulting Training Blog Careers About Us Contact Us

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 Training

Course ID: MSL-55005
Duration: 2 Days

Upcoming Classes

Sorry, nothing scheduled right now. Click the Get Notified button below to be alerted when a class is scheduled.

Get Notified

On Site/Private

Can't find a class that fits right for you? Contact us to inquire about scheduling your own private class

Contact Us

Description

This instructor-led course provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL 2012, and SQL 2014 Standard and Enterprise, so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release.

The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters, a detailed section exploring report expressions and how to properly configure them, filters, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts, subreports, subscriptions, and exporting options.

Bring This Course To You

For groups of 5 or more, let Intertech bring this course to your location. Customized versions tailored towards your objectives are also available.

Learn More

Learning Objectives

After completing this course, students will be able to: 

  • Plan the reports.
  • Use Report Builder 3.0 and understand the parts of the interface.
  • Launch Report Builder 3.0 from multiple sources.
  • Understand management options.
  • Create embedded data sources and datasets.
  • Create shared data sources and datasets.
  • Create shared data sources and datasets.
  • Understand and utilize the Table or Matrix Wizard.
  • Understand and utilize the Chart Wizard.
  • Understand and utilize the Map Wizard.
  • Understand and utilize lists.
  • Understand and utilize tables.
  • Understand and utilize matrices.
  • Understand and utilize data regions.
  • Understand and utilize parameters.
  • Understand and utilize expressions.
  • Understand and utilize report parts.
  • Understand and utilize formatting options.
  • Understand visualization options.
  • Understand and utilize charts.
  • Understand and utilize sparklines.
  • Understand and utilize gauges.
  • Understand and utilize maps.
  • Understand filtering, grouping, and sorting.
  • Understand and utilize dynamic headers and footers.
  • Understand and utilize report templates.
  • Understand and utilize HTML and texboxes.
  • Understand and utilize lists as containers.
  • Understand and utilize subreports.
  • Understand report subscription options.
  • Understand security.

Audience

This course is intended for Power Users, Developers and IT Professionals that will be involved with the design, development and maintenance of reports created with Report Builder 3.0

Prerequisites


Before attending this course, students must have a basic understanding of relational databases.

Course Outline

Module 1: Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing

Lab : The training environment

  • Become familiar with the class setup

After completing this module, students will be able to:

  • Log on
  • Run the labs
  • Locate the example files

Module 2: Introduction to Report Builder 3.0

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Plan your reports
  • The Interface
  • Variances between SQL versions
  • How to use Report Builder 3.0 with SQL Express 2012
  • Data Sources
  • Data Sets

Lab : Introduction to Report Builder 3.0

  • Explore Report Builder 3.0
  • Create embedded Data source and sets
  • Create shared Data Source and Sets

After completing this module, students will be able to:

  • Plan the reports
  • Use Report Builder 3.0 and understand the parts of the interface
  • Launch Report Builder 3.0 from multiple sources
  • Create embedded and shared data sources and data sets

Module 3: Report Builder 3.0 Wizards

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Explore the Report Builder 3.0 Wizards
  • Create reports with the Wizards

Lab : Report Builder 3.0 Wizards

  • Use the Wizards to create reports

After completing this module, students will be able to:

  • Use the Wizards to create reports

Module 4: Report Builder 3.0 Basic Reports

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Report Lists
  • Report Tables
  • Report Matrix
  • The Data Region
  • Report Parameters
  • Report Expressions
  • Formatting Reports

Lab : Report Builder 3.0 Basic Reports

  • Create a report using a List
  • Create a report using a Table
  • Create a report using a Matrix
  • Create a report using multiple Data Regions
  • Use Report Parameters
  • Use Report Expressions
  • Format the report
  • Save Report Parts for reuse

After completing this module, students will be able to:

  • Create a report using a List
  • Create a report using a Table
  • Create a report using a Matrix
  • Create a report using multiple Data Regions
  • Use Report Parameters
  • Use Report Expressions
  • Format the report

Module 5: Report Builder 3.0 Graphics

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Report Charts
  • Report Images
  • Report Gauges
  • Report Maps

Lab : Report Builder 3.0 Graphics

  • Create a report with Charts
  • Create a report with Images
  • Create a report with Gauges
  • Create a report with Maps

After completing this module, students will be able to:

  • Create a report with Charts
  • Create a report with Images
  • Create a report with maps
  • Create a report with Gauges

Module 6: Intermediate Reports

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Time Intelligence
  • Sub Reports
  • Interacting with Actionable Reports
  • Reuse Report Parts

Lab : Intermediate Reports

  • Create Sub Reports
  • Create a report that allows interaction
  • Reuse Report Parts
  • Use Time Intelligence

After completing this module, students will be able to:

  • Create Sub Reports
  • Create a report that allows interaction
  • Reuse Report Parts
  • Use Time Intelligence

Module 7: Report Builder 3.0 Tips and Tricks

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

Over 100 step-by-step examples for report situations

Lab : Report Builder 3.0 Tips and Tricks

  • Over 100 step-by-step examples for report situations

After completing this module, students will be able to:

  • Use the tips and tricks

Free Resources from Intertech

Free On-Demand Videos: SSRS Report Builder Tips

Free SQL Server Whitepaper: Performance Tuning

Quick Start: Learn DAX Basics in 30 Minutes

X