Welcome to ONLC Training Centers


Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and SQL 2012 - 55005 Course Outline

 (2 days)
Version 2012

Overview
Builder 3.0. The training environment includes SQL 2008R2, SQL Express 2012 and SQL 2012 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 and report expressions, report visualizations including graphs, charts, images and gauges, advanced reporting including the utilization of maps, interactive reports, report parts and Sub-Reports.

The course concludes with a special module that includes over 100 tips and tricks for Report Builder 3.0 with step-by-step instructions. All of the examples are available as a take-away for the students after the course.

Prerequisites
Before attending this course, students must have:
A basic understanding of relational databases.

Audience Profile
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

At Course Completion
After completing this course, students will be able to: Plan your reports
Utilize Report Builder 3.0 Wizards
Create an embedded data source
Create an embedded data set
Create shared data sources and data sets
Use report parameters
Use report expressions
Create report gauges
Create report graphs
Use images in reports
Use report lists
Use report tables
Use the matrix
Create maps in reports
Create sub reports
Use report parts
Create interactive reports
Use keyboard shortcuts

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

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

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

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

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

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

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
View outline in Word

A55005

Attend hands-on, instructor-led Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and SQL 2012 - 55005 training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of SQL Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $1195

Savings options:

 15 Day Pass
 CEA Tech Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com