55128 Writing Reports with Report Builder and SSRS Level 2

Course Details

• At Course Completion
• Incorporate the use of single valued parameters, multi-valued parameters, range parameters, and cascading parameters in a report
• Add default values for parameters
• Create a list of available values for a parameter and Create date range parameters
• Troubleshoot failing parameter reports and Create free-form reports with rectangles
• Use master-detail data with report objects, Troubleshoot and resolve master-detail data errors in reports
• Use conditional formatting to enhance data presentation, Define and implement running values
• Create TOP N reports, Format reports for presentation and analysis
• Troubleshoot and resolve failing TOP N filters and reports, Use a Visual Basic procedure in a report
• Use images to enhance reports and display images stored in databases, Use advanced report formatting techniques
• Understand composite reports which use different page layouts, Incorporate the use of cascading parameters in reports
• Use mini-charts and mini-gauges in reports, Use mini-gauges to create a scorecard
• Troubleshoot and resolve failing features of a mini-chart report
• Module 1: Parameter Reports - This module reviews dynamic reporting through the use of parameters.
• Parameterized reporting
• Creating and Modifying Parameters
• Creating Default Values and Available Values for Parameters
• Lab 1: Parameterized Reports
• Create a Report which uses a Single-Value Parameter and Multi-Value Parameter
• Create a Report which provides a List of Available Parameter Values to Choose From
• Create a Report with using Multiple Parameters, Default Parameter Date Range Values, and Available Values
• Troubleshoot Failing Parameter Reports which use Multiple Parameters, Default Parameter Values, and Available
• Parameter Values
• Module 2: Creating Custom Reports with Rectangles and Master-Detail Data
• Introducing Rectangles and Lists
• Create Reports using Rectangles and List Data Regions
• Modify Reports which use Rectangles and List Data Regions
• Lab 1: Create Custom Reports using Lists, Master-Detail Data, and Rectangles
• Create a Report with Rectangles, Lists, Tables, and Master-Detail Data
• Create an Invoice Report with a Rectangles, Lists, Tables, and Text Boxes
• Module 3: Enhancing Reports with Formatting and Complex Expressions
• Enhancing Report Appearance
• Using Running Values to Provide Totals and Subtotals
• Creating and Using Top N Reports
• Lab 1: Enhancing Reports with Complex Expressions
• Analyze Report Data with Conditional Formatting
• Use Complex Expressions in Charts
• Calculate a Running Value
• Create TOP N Reports
• Format a Table with Alternate Row Shading
• Matrix Report Alternate Row Shading with Visual Basic
• Module 4: Enhance Reports with Images and Subreports
• In this module, students will add images and reports (subreports) to reports.
• Adding Images to Reports
• Retrieving Images from a Database
• Introducing SQL Server Reporting Services Report Manager
• Adding Subreports to Reports
• Lab 1: Working with Images and Subreports
• Enhancing an Existing Report with Images
• Adding Subreports to a Report
• Adding Parameterized Subreports to Reports
• Module 5: Drilldown and Drillthrough Reports
• This module explains how to add drilldowns to your report to allow your audience the ability to uncover layers of detail about your summarized content.
• Drilldowns
• Drillthroughs
• Lab 1: Summarize Data with Drilldowns and Drillthroughs
• Adding Drilldowns to Control Report Detail
• Add Drilldown Behavior to a Group
• Add Drilldown Behavior to a Group Hierarchy
• Analyze Data using Drillthrough Behaviors in a Report
• Module 6: Inline Data Analysis with Mini-charts and Mini-Gauges
• This module introduces the use of mini-charts and mini-gauges in report writing.
• Mini-Charting with Graphs of Data
• Mini-Charting with Bars of Data
• Mini-Gauging with Scorecards
• Lab 1: Analyze Data with Mini-Charts and Mini-Gauges
• Analyze Data with Indicators and Data Bars
• Analyze Data with Sparklines
• Use Indicators to Analyze Data with a Scorecard