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.
Before attending this course, students must have:
A basic understanding of relational databases.
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.
Job role: Developer
After completing this course, students will be able to:
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lab : Course Overview
Introduction to Report Builder 3.0
This module introduces the interface of Report Builder 3.0, the different features available, and variances in data sources and datasets.
Lab : Introduction to Report Builder 3.0
Report Builder 3.0 Wizards
This module covers report basics exploring lists, matrices, and tables along with the wizards. Data regions will also be explained.
Lab : Report Builder 3.0 Wizards
Report Builder 3.0 Basic Reports
In this module we examine parameters, filters, and the expressionable aspect of reports. We also cover formatting options.
Lab : Report Builder 3.0 Basic Reports
Report Builder 3.0 Graphics
This module is a detailed look at graphics including charts, images, sparklines, data bars, gauges, and Bing maps.
Lab : Report Builder 3.0 Graphics
This module covers intermediate reporting with emphasis on actionable reports, and a section exploring report subscriptions and security.
Lab : Intermediate Reporting
Report Builder 3.0 Tips and Tricks
This module is optional and contains 20 tips and tricks with step-by-step instructions.
Lab : Report Builder 3.0 Tips and Tricks
Microsoft Power Platform App Maker
Designing & Implementing Azure AI Solution
Microsoft Azure Administrator
Developing Solutions For Microsoft Azure
Microsoft Azure Architect Design Exam
Implementing Azure Data Solution
Administering Relational Databases On Microsoft Azure