Microsoft 55123: Writing Reports with Report Builder and SSRS Level 1

• 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

This course is likely to add to the employment-related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

• Report Builder and SSRS report authors
• Report Designer
• Business analysts
• Programmer analysts
• Data analysts
• Database administrators
• IT professionals

• Exploring the Report Builder Environment
• Introducing the Report Builder Environment
• Working with Existing Reports
• Exploring the Report Builder Application
• 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
• Adding Data to Table Reports
• Create Report Data Sources
• Create Report Datasets
• Work with the Tablix Data Region
• Create a Table Report
• Creating Table Reports
• Create Queries Using the Report Builder Query Designer
• 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
• Create a table report
• 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
• Formatting Reports
• 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
• Grouping Report Data
• Group Data in Reports
• Group Data Using an Expression
• Creating Subgroups and Group Aggregates
• Creating Reports with Groups and Aggregates
• Display Grouped Data in a Report
• 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
• Creating and Modifying Matrix Data Regions
• Creating and Modifying Column Groups
• Creating Matrix Reports
• Create Matrix Reports
• 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
• Create and Modify Chart Wizard Reports
• Add Charts to Existing Reports
• Modify Charts in Reports
• Creating Charts and Chart Reports
• Create a Chart Wizard Report
• Add a Chart to an Existing 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
• Print Features and Print Options
• Export Reports
• Printing and Exporting Reports
• 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