Creating Reports with Report Builder Courseware (REPBLD101)

This class is geared toward business analysts and data consumers who need to be able to successfully create reports on a SQL Server Reporting Services server.

After this course participants should be able to:

• Understand data sources and create datasets.
• Create and format reports.
• Create, summarize, and sort groups.
• Add flexibility to the groups using parameters.
• Enhance data with charts and maps.
• Create custom expressions.

1- SSRS Overview

• Reporting Services Features
• Tools Available with SQL Server 2016
• Authoring with Report Builder
• ClickOnce vs. Stand-alone (Optional)
• The Getting Started Dialog Box

2- Data Sources and Datasets

• What is a Data Source?
• Shared verses Embedded Data Sources
• What is a Dataset?
• Creating Datasets

3- Creating New Reports

• Using the Report Wizards
• Starting from the Blank Report Template
• What is Tablix?
• Creating a Tabular Report
• Creating a List Report
• What is a Matrix?

4- Formatting Reports

• Working with Text Boxes
• Rich Text Formatting
• Managing Text Boxes
• Drawing Lines and Boxes
• Images
• Page Headers and Footers
• Adding a document map
• Rendering Reports

5- Summarizing and Sorting

• Creating Groups
• Adding Totals and Aggregations
• Parent/Child vs. Adjacent Groupings
• Tablix Properties and Grouping Data

6- Add Flexibility with Parameters

• Adding Parameters to a Report
• Report Parameters vs. Query Parameters
• Working with Cascading Parameters
• Manage Report Parameter Properties
• Use Parameters with SQL Queries and Stored Procedures
• Sort Based on a Parameter Setting
• Filtered Reports

7- Enhanced Report Items

• Charts
• Gauges
• Add a Map to a Report
• Data Bar, Indicator, and Sparkline Report Items
• Nesting Data Regions
• Subreports and Drillthrough Reports
• Working with Drillthrough Reports

8- Custom Expressions

• Understanding Expressions
• Defining Expressions
• Working with Report Variables
• Understanding Lookup, LookupSet, and Multilookup Functions
• Expression Samples

Required Prerequisites

• General knowledge of database concepts including tables and fields.
• Be comfortable working in Microsoft Office.

Useful Prerequisites

• Strong prior Excel experience is helpful but definitely not required.

None

None