SSRS 2012 Training: Introduction to SQL Server 2012 Reporting Services

Course Number: SQL-320
Duration: 3 days
view class outline

Looking for SSRS 2008 training?

SSRS 2012 Training Overview

Accelebrate's Introduction to SQL Server 2012 Reporting Services (SSRS) training teaches attendees how to create, format, and manage SQL Server 2012 Reporting Services reports.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=mssql.

SSRS 2012 Training Prerequisites

All attendees must have a general familiarity with databases prior to the class. Working knowledge of Microsoft SQL Server or Microsoft Office applications is beneficial.

Hands-on/Lecture Ratio

This SSRS 2012 training is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.

SSRS 2012 Training Materials

All attendees receive a copy of SQL Server 2012 Reporting Services for Report Writers.

Software Needed on Each Student PC

At least 6GB RAM
At least 10GB free disk space
Windows Vista SP2 or later, or Windows 7 SP1 or later, Windows Server 2008 SP2 or later. Operating system required depends on the edition of SQL Server that is being used.
A full installation of the SQL Server 2012 with the latest service packs installed, as well as all client tools.
Note: This class is written to support a SQL Server Native Mode environment. Customization will be required to run Reporting Services in SharePoint integrated mode.
Related sample databases and lab files that Accelebrate provides
Adobe reader, Microsoft Word, and Microsoft Excel

Important Note: If you have purchased this class, please contact us for detailed setup instructions.

SSRS 2012 Training Objectives

All attendees will learn to:

Use SSRS tools
Work with solutions and projects
Design basic reports
Enhance reports with formatting, images, and charts
Effectively group and summarize data
Work with parameterized reports
Incorporate charts and custom maps
Work with drillthrough reports
Manage reports
Utilize Report Builder

SSRS 2012 Training Outline

SSRS Overview and Tools

Reporting Services Features
Tools Available with SQL Server 2012
SQL Server Documentation

Working with Solutions and Projects

Working with SQL Server Data Tools
Understanding Solutions and Projects
Working with the Visual Studio Interface

Creating Basic Reports

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

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

Custom Expressions

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

Summarizing and Sorting

Creating Groups
Parent/Child vs. Adjacent Groupings
Adding Totals and Aggregations
Creating Aggregates of Aggregates

Add Flexibility with Parameters

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

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

Using Report Manager

Deployment
Navigating Report Manager
Understanding Permissions
Viewing Reports
Working with Shared Data Sources
Managing Reports

Using Report Builder for SQL Server 2012

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

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.