Quick Microsoft SQL Server 2012 Reporting Services

Version Changes of SSRS from 2008-2012

Reporting Services Installation and Architecture

Reporting Services Tools

Lab : Introduction to Microsoft SQL Server Reporting Services

Reporting Services Tools

Understand version changes of SSRS from 2008-2012.

Understand Reporting Services installation and architecture.

Understand and utilize Reporting Services tools.

In this module, we begin building reports using the basics. We will explore the wizards available and then cover tables, matrices, and lists while demonstrating how to use each of them. Finally, we will take a look at the report items available to help design the report.

Wizards

Data Sources

Datasets

Understanding Security in Connections

Tables

Matrix

List

Report Items

Report Parts

Wizards

Data Source Connections

Data Sources

Datasets

Tables

Matrix

List

Report Parts

Concept Reinforcement Scenario 1

Understand and utilize Wizards.

Create and configure data sources.

Create and configure datasets.

Understand security in connections.

Create and configure Tables.

Create and configure Matrices.

Create and configure Lists.

Understand and utilize Report Items.

Understand and utilize Report Parts.

Visualize and present your data using visualizations. In this module, we cover the visualizations available, while demonstrating each, so you can see for yourself just how captivating data can be.

Charts

Gauges and Dashboards

Maps

Sparklines, Data Bars, and Indicators

Charts

Gauges

Maps

Data Bars and Sparklines

Concept Reinforcement Scenario 2

Understand and utilize Charts.

Understand and utilize Gauges.

Understand Dashboards.

Understand and utilize Maps.

Understand and utilize Data Bars.

Understand and utilize Sparklines.

Understand Key Performance Indicators.

Looking to take reporting to the next level? Then look no further. In this module, we cover what you’ll need to create advanced reports with features such as conditional formatting and interactivity just to name a few.

Expressions

Functions

Interactivity

Parameters

Conditional Formatting

Templates

Subreports

Expressions and Functions

Parameters Using Two Datasets

Query Parameters

Fixed Parameters

Conditional Formatting

Subreports

Concept Reinforcement Scenario 3

Understand and utilize Expressions.

Understand and utilize Functions.

Understand and utilize Interactivity.

Understand and utilize Parameters.

Understand and utilize Conditional Formatting.

Understand Templates.

Understand and utilize Subreports.

To share your report, you need to publish or deploy it to a report server or SharePoint site. In this module, we explain deployment options and follow with an explanation on security and administrative tasks.

Deploying Reports

Securing Content

Caching

Snapshots

History

Viewing Reports Online

Utilizing Subscriptions

Data Alerts

Deployment Properties with SQL Server Data Tools

Report Builder 3.0 Deployment

Reporting Services Roles

Caching

Snapshots and History

Shared Schedule

Subscriptions

Concept Reinforcement Scenario 4

Deploy reports.

Secure and manage content.

Understand and utilize Caching.

Understand and utilize Snapshots.

Understand and utilize Report History.

Understand how to complete other administrative tasks.