Over 2 days you'll learn the foundations of report writing with Report Builder and SSRS. Report Builder 3.0 is available for Microsoft® SQL Server® versions 2014, 2012, and 2008 R2.
Suitable for All Levels
2 Day Classroom Course
Study materials included
Skills You will have at the end of the Course
Understand the report design process.
Creating and editing new and existing SSRS reports.
Understand how to connect to and filter different data sources.
Understand how to layout and format SSRS reports.
In this 2-day course, students will learn the foundations of report writing with Report Builder and SSRS. The focus will be on report writing by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, sorting and filtering data, charting data, and preparing reports for printing and exporting. Report Builder 3.0 is available for Microsoft® SQL Server® versions 2014, 2012, and 2008 R2.
You will learn to:
- Navigate the Report Builder Environment
- Create table reports
- Format reports
- Create basic and complex expressions
- Group report data
- Create matrix reports.
- Sort and filter data.
- Summarize data with charts.
- Print and export reports.
No prior knowledge is required.
At the end of the course, you’ll be Certified by the Irish Academy of Computer Training
Who would benefit
The primary audience for this course are persons who are new to reporting with Microsoft® SQL Server® Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors.
The secondary audience for this course are persons who are using Report Designer (SSRS).
Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft® SQL Server® Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.
Why take the Course
To become proficient in building and developing user-friendly, robust, and scalable SSRS Reports.
Section 1: Exploring the Report Builder Environment
In this section, you’ll learn the essentials of working with SSRS;
- Introducing the Report Builder Environment.
- Working with Existing Reports.
- Navigating the Ribbon and Window panes.
- View Existing Reports in Design and Run modes.
- Describe and navigate the graphical elements of the Report Builder application.
- Work with existing reports and navigate between Design and Run modes.
Section 2: Adding Data to Table Reports
In this section, you’ll look at how to populate a report with data and display that data in a table data region on the report.
- Create Report Data Sources
- Create Report Datasets
- Work with the Tablix Data Region
- Create a Table Report
- Create Queries Using the Report Builder Query Designer
- Create Table Relationships Using Query Designer
- Create a Table Report Using Multiple Tables
- Create report data sources.
- Create report datasets.
- Work with the tablix data region.
Section 3: Formatting Data and Creating Expressions in Reports
This section introduces report formatting techniques which allow a report writer to control how and where data displays in the report.
- Formatting Reports
- Sorting and Filtering Report Data
- Adding Data to a Dataset
- Creating Simple Expressions
- Creating Complex Expressions
- Format Tablix Columns
- Format Data in a Tablix Cell Using Properties
- Format Data in a Tablix Cell Using Simple and Complex Expressions
- Sort Data Using Expressions
- Use Simple and Complex Expressions to Display Data in a Tablix
- Format data in a report using the Report Builder Properties dialog boxes.
- Add data to a report and make changes to column names in the dataset query.
- Format data in a report using simple and complex expressions.
- Display data in a report using simple and complex expressions.
Section 4: Grouping Report Data
This section introduces data groupings in reports using dataset fields and using expressions. This section also discusses group hierarchies and adding aggregates to summarize grouped data.
- Display Grouped Data in a Report
- Group Data Using an Expression
- Creating Subgroups and Group Aggregates
- Create a Group Hierarchy in a Report
- Group Data Using a Complex Expression
- Add Aggregates to Tablix Rows
- Configuring a Reference Image
- Group data in reports using fields
- Group data in reports using expressions.
- Create group hierarchies.
- Aggregate grouped data in a report.
Section 5: Matrix Reports
This section introduces matrix data regions which are used in reports to control how cross tabular data can be used. While table reports rely on rows and columns, matrix reports rely on row groupings, column groupings, and aggregated values.
- Creating and Modifying Matrix Data Regions
- Creating and Modifying Column Groups
- Create Column Groups
- Use Expressions to Sort Group Data
- Use Expressions to Display Group Names
- Create Matrix Reports with Group Hierarchies
- Describe the key features of using a matrix in a report.
- Create and modify matrix reports.
- Define column group hierarchies.
- Use expressions to define matrix headings and sort orders.
Section 6: Charts
This section introduces charts, and adding charts to reports.
- Add Charts to Existing Reports
- Modify Charts in Reports
- Create a Chart Wizard Report
- Use Expressions in Charts
- Use Expressions in Charts
- Describe the key features of charts.
- Create charts using the Chart Wizard and the Ribbon.
- Modify chart data and the formatting of chart elements.
- Use expressions in charts.
Section 7: Printing and Exporting Reports
This section introduces report printing and exporting. Reports can be created for electronic display, paper display, or display in another application. This section covers the basics of those three scenarios.
- Print Features and Print Options
- Exploring Page Layout view, Report Formatting, and Page Setup Options
- Exporting Reports
- Describe the key features of electronic reporting vs. print reporting.
- Prepare a report for paper printing.
- Export reports in supported formats.