Contact Us

Contact Us





    Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014 2 days | | $1,190 PLUS TAX

    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. Prerequisite: 

    TARGET 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

    COURSE 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.

    COURSE OUTLINE

    EXPLORING THE REPORT BUILDER ENVIRONMENT

    • » Introducing the Report Builder Environment
    • » Working with Existing Reports
    • » Lab: Exploring the Report Builder Application

    ADDING DATA TO TABLE REPORTS

    • » Create Report Data Sources
    • » Create Report Datasets
    • » Work with the Tablix Data Region
    • » Create a Table Report
    • » Lab: Creating Table Reports

    FORMATTING DATA AND CREATING EXPRESSIONS IN REPORTS

    • » Formatting Reports
    • » Sorting and Filtering Report Data
    • » Adding Data to a Dataset
    • » Creating Simple Expressions
    • » Creating Complex Expressions
    • » Lab: Formatting Reports

    GROUPING REPORT DATA

    • » Group Data in Reports
    • » Group Data Using an Expression
    • » Creating Subgroups and Group Aggregates
    • » Lab: Creating Reports with Groups and Aggregates

    MATRIX REPORTS

    • » Creating and Modifying Matrix Data Regions
    • » Creating and Modifying Column Groups
    • » Lab: Creating Matrix Reports

    CHARTS

    • » Create and Modify Chart Wizard Reports
    • » Add Charts to Existing Reports
    • » Modify Charts in Reports
    • » Lab: Creating Charts and Chart Reports

    PRINTING AND EXPORTING REPORTS

    • » Print Features and Print Options
    • » Export Reports
    • » Lab: Printing and Exporting Reports
    • Please call for dates