Microsoft 55128: Writing Reports with Report Builder and SSRS Level 2

• Create parameter reports
• Create list reports
• Format reports with complex expressions
• Add images and subreports
• Add drilldown and drillthrough functionality
• Add sparklines, data bars, and indicators

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

• Parameter Reports
• Parameterized Reporting
• Create Report Parameters
• Modify Report Parameters
• Provide Default Parameter Values
• Provide Available Values for Parameters
• Creating Parameterized Reports
• Create Single Value Parameter Reports
• Create Multi-Value Parameter Reports
• Create an Available Values Parameter Report
• Create a Parameter Report with Default Values
• Modify Existing Parameter Reports
• Describe the key benefits and features of report parameters
• Create parameterized queries and parameterized reports
• Create parameters which accept single values, multiple values, expose or hide the parameter value, provide a list of available parameter values, and provide parameters with default values
• Modify existing parameters and parameter reports
• List Data Regions
• Introducing the List Data Region
• Create Reports Using List Data Regions
• Modify Reports Which Use List Data Regions
• Creating List Reports
• Create a Multiple Column Report with List Data Regions
• Create a Report with Rectangles and Nested Data
• Create a Report with Rectangles and Nested Data
• Describe the benefits of list data regions and rectangles in reporting scenarios
• Create reports which display data in multiple columns
• Create reports which take advantage of nested data
• Create enhanced reports using list data regions and rectangles
• Enhancing Reports with Complex Expressions
• Formatting Reports
• Top N Reports
• Running Values
• Enhancing Reports with Complex Expressions
• Create Conditional Formats for Data
• Use Complex Expressions in Charts
• Calculate Running Values in Table and Matrix Data Regions
• Create TOP N Reports
• Create Conditional Formats for Data
• Create conditional formats for data displayed in a report
• Use complex expressions in charts
• Calculate running values for groups and datasets
• Create TOP N reports for groups and datasets
• Use row banding in a data region
• Enhance Reports with Images and Subreports
• Add Images to Reports
• Retrieve Images from a Database
• Introducing SSRS (SQL Server Reporting Services) Report Server
• Add Subreports to Reports
• Working With Images and Subreports
• Add an Image to an Existing Report
• Display Images from a Database in a Report
• Format HTML5 Data to Display Properly in a Report
• Use SSRS Report Server to Facilitate Subreporting
• Add Subreports to a Report
• Add Parameterized Subreports to Reports
• Describe the available options for adding images to reports
• Add images to reports
• Describe the features of SSRS Report Server
• Add subreports and parameterized subreports to reports
• Drilldown and Drillthrough Reports
• Add and Configure Drilldown Reporting
• Add and Configure Drillthrough Reporting
• Add Drilldown and Drillthrough Functionality to Reports
• Add Drilldown Functionality to Text Boxes
• Add Drilldown Functionality to Groups
• Add Drilldown Functionality to Group Hierarchies
• Add Drillthrough Functionality to a Report
• Add Parameterized Drillthrough Functionality to a Chart
• Describe the key features of drilldowns and drillthroughs in a report
• Add drilldowns to Reports
• Add drillthroughs to Reports
• Add parameterized drillthroughs to Reports
• Sparklines, Data Bars, and Indicators
• Sparklines
• Data Bars
• Indicators
• Adding Sparklines, Data Bars, and Indicators to Reports
• Create Group Charts
• Add Indicators and Data Bars to a Report
• Add Sparklines to a Report
• Add Indicators to a Report
• Add Sparklines, Data Bars, and Indicators to a Report
• Describe the key features of incorporating mini-charts and mini-gauges in reports
• Add and modify sparklines, data bars, and indicators in reports