SQL Server 2012 Reporting Services

This module covers working with solutions and projects within Visual Studio.

Working with SQL Server Data Tools

Understanding Solutions and Projects

Working with the Visual Studio Interface

Creating and Managing a Project

Work with SQL Server Data Tools.

Understand solutions and projects.

Work with the Visual Studio interface.

This module covers building reports from start to finish, and tips and tricks for successful report building.

What is a Data Source?

What is a Dataset?

Using the Report Wizard

What is Tablix?

Creating a Tabular Report

Creating a List Report

What is a Matrix?

Deploying a Project

Creating Shared Data Sources and Datasets

Using the Report Wizard

Building a Basic Matrix Report

Understand the differences between shared and embedded data sources and datasets.

Create shared and embedded data sources and datasets

Use the Report Wizard to build basic reports.

Create a basic matrix report from a shared dataset.

This module covers the features which enhance the visual impact of 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

Formatting a Tablix Data Region

Enhancing a Report

Format data to enhance a report.

Add images to a report.

Work with page headers and footers.

This module covers expressions and how to use them to set dynamically changing properties or values.

Understanding Expressions

Defining Expressions

Working with Report Variables

Understanding Lookup, LookupSet, and Multilookup Functions

Expression Samples

Using Expressions to Work with Dates

Using Expressions to Manipulate Data

Use expressions to work with custom formulas.

Use expressions to change the way data is displayed in report.

Use expressions to incorporate data from more than one dataset.

SQL Server Reporting Services (SSRS) offers grouping features to allow you to summarize data and then drill down into the details below the summary levels. This module will explain how to create and manage these groupings.

Creating Groups

Parent/Child vs. Adjacent Groupings

Adding Totals and Aggregations

Creating Aggregates of Aggregates

Adding Parent Groups to a Report

Working with Groups

Add both row and column parent groups to an existing report.

Aggregate data for summary reports.

Create reports using adjacent groups in a matrix.

Work with group properties.

Paramaterized reports allow users to customize reports to show only the data they are interested in. This module covers the use of parameters and filters.

 Adding Parameters to a Report

Report Parameters vs. Query Parameters

Manage Report Parameter Properties

Use Parameters with SQL Queries and Stored Procedures

Work with Cascading Parameters

Sort Based on a Parameter Setting

Filtered Reports

Adding Parameters

Customize report data with both query and report parameters.

Use parameters to define interactive sort and visibility options.

Add filters to a dataset.

This module explores the different ways data can be enhanced visually in a report.

Charts

Gauges

Add a Map to a Report

Data Bar, Indicator, and Sparkline Report Items

Nesting Data Regions

Sub-reports and Drill-through Reports

Working with Drill-through Reports

Creating a complete solution (if time permits)

Adding data visualization report items to a report

Adding a correlated sub-report

Use lessons up to this point to create a complete solution.

Choose between data visualization options.

Add data visualization items to an existing report.

Add a drill-through report send parameters to the drill-through report.

This module provides details on how to run and manage reports using Report Manager.

Deployment

Navigating Report Manager

Understanding Permissions

Viewing Reports

Working with Shared Data Sources

Managing Reports

Lab : Using Report Manager

Creating and Deploying Projects

Working with Report Manager

Create and deploy a project by using SSDT.

Work with Report Manager to view and manage reports.

Create a linked report.

Add report snapshots by using Report Manager.

This module covers the use of Report Builder to apply lessons learned in previous modules.

ClickOnce vs. Stand-alone

Installing the Stand-alone Version

Using the Report Builder Tool

Creating Datasets

Creating Reports

Creating Reports Using Wizards

Creating Reports Without a Wizard

OPening Existing Reports

Working with Report Parts

Creating a basic report by using Report Builder

Adding data visualization report items to a report

Implement basic features from previous modules in Report Builder

Add data visualization items to a report using Report Builder.