Writing Reports with Report Designer and SSRS Level 1
About this course
Please use this link to access Course # 552040 for dates as part of Boot Camp, or call for more information
These 3 courses, Level 1-3, are offered in a 5 day Boot Camp course # 552040 or can be purchased separately.
55204 Writing Reports with Report Designer and SSRS Level 1 (2 days) Monday/Tuesday
55170 Writing Reports with Report Designer and SSRS Level 2 (2 days) Wednesday/Thursday (Use this link to access Course 55170)
55240 Writing Reports with Report Designer and SSRS Level 3 (1 day) Friday (Use this link to access Course 55240)
In this 2-day course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server Report Designer and SSRS. The focus will be on report creation by connecting to a database and manipulating the data for presentation including: creating parameter reports, creating list reports, adding complex expressions to reports, adding images and subreports to reports, adding drilldown and drillthrough functionality, and adding sparklines, data bars, and indicators to reports. Report Designer is available for all supported versions of Microsoft® SQL Server.
The primary audience for this course are persons who are new to reporting with Microsoft® SQL Server® Report Designer and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Designer 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 Designer and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.
After completing this course, students will be able to:
- Navigate the Report Designer 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.
Module 1: Exploring the Report Designer Environment
This module introduces the Report Designer application and its features. You will explore the Ribbon and its Tabs, Command groups, and Commands, the available Window panes for creating and manipulating reports, and the report design surface using Design and Run modes.
- SQL Server Reporting Services.
- Introducing the Report Designer Environment.
- Working with Existing Reports
Lab: Exploring the Report Designer Application
Module 2: Adding Data to Table Reports
This module introduces how to populate a report with data and display that data in a table data region on the report. We will begin with defining the data source and continue with query building through data sets to bring data into the report. Next, we will explore the elements of the tablix data region including rows, columns, cells, handles, and field choosers, you will use in displaying your data.
- Create Report Data Sources
- Create Report Datasets
- Create a Table Report
Lab : Creating Table Reports
Module 3: Formatting Data and Creating Expressions in Reports
This module introduces report formatting techniques which allow a report writer to control how and where data displays in the report. Additional data may also be required and this can be accomplished by adding data from a source or adding a calculated field to the dataset. Simple and complex epressions will also be introduced in this topic.
- Formatting Reports
- Sorting and Filtering Report Data
- Adding Data to a Dataset
- Creating Simple Expressions
- Creating Complex Expressions
Lab : Formatting Reports
Module 4: Grouping Report Data
This module introduces data groupings in reports using dataset fields and using expressions. This module also discusses group hierarchies and adding aggregates to summarize grouped data.
- Group Data in Reports
- Group Data Using an Expression
- Creating Subgroups and Group Aggregates
Lab : Creating Reports with Groups and Aggregates
Module 5: Matrix Reports
This module introduces matrix data regions which are used in reports to control how crosstabular 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
Lab : Creating Matrix Reports
Module 6: Charts
This module introduces charting and the ability to create and add charts to reports. Chart reports allow us to visualize data with or without the details.
- Create and Modify Charts in Reports
- Modify Charts in Reports
Lab : Creating Charts and Chart Reports
Module 7: Printing and Exporting Reports
This module introduces report printing and exporting. Reports can be created for electronic display, paper display, or display in another application. This module covers the basics of those three scenarios.
- Print Features and Print Options
- Export Reports
Lab : Printing and Exporting Reports
This course requires that you meet the following prerequisites:
- Familiarity with Windows.
- Creating and navigating folders.
- Opening programs.
- Manipulating windows.
- Copying and pasting objects.
- Formatting text.
- Saving files.
- Microsoft® Office Access 2013: Level 1 or have equivalent experience with basic database concepts.
*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.