Microsoft SQL Server 2008 Reporting Services

Course:  SSRPT
Duration:  3 Days
Level:  II
Course Summary

This course teaches students the techniques for using SQL Server 2008 Reporting Services. They will learn about tabular and list reports that employ datasets and data regions. This course will also teach students how to add custom expressions, custom functions and format reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports created in the course will employ shared data sources, interactive sorting, and drill-down capabilities. Students will learn how Reporting Services parameters work and create parameters in ad-hoc SQL. They will also build Matrix reports and charts to help understand the use of Reporting Services gauges. Deployment of Reporting Services projects using a variety of formats and client-side printing will be covered. Students will learn how SSRS Security works for managing user roles and accounts.

« Hide The Details
Topics Covered In This Course

Introducing SQL Server Reporting Services

  • Reporting Services overview
  • Architecture
  • Components
  • Basic report using the SQL Server Reporting Services Wizard

Creating Tabular and List Reports

  • Tabular report without the wizard
  • Dataset usage
  • Report textboxes and other controls
  • List data regions

Calculation and Formatting

  • Expressions
  • Custom functions
  • Global collections
  • Formatting toolbars, the Properties window, and the Textbox Properties dialog box
  • Conditional formatting
  • Report variables

Grouping and Sorting

  • Overview
  • Grouping pane
  • Group totals and percentages
  • Scope as it applies to aggregate functions
  • Sorting
  • Drill-down reports

Working with Parameters

  • Stored procedure parameters
  • Parameters in ad-hoc SQL
  • Parameter values in report headers
  • Parameter prompts using drop-down list parameters
  • Unbound, multi-valued, and cascading parameters
  • Troubleshooting

Creating Matrix Reports and Charts

  • Overview
  • Charts
  • Gauges

Managing Reporting Services

  • Plan and configure deployment
  • Deploy Reporting Services projects, individual reports and data sources
  • Client-side printing
  • Report Manager
  • Linked reports

Security

  • Overview
  • User accounts and roles
  • Authentication
  • SSL
  • Credentials within a data source

Programming Reporting Services

  • Programming interfaces
  • URL to integration
  • Report Viewer controls for Web pages
  • Local mode options

Advanced Reporting Services Programming

  • Reporting Services Web Service API
  • Calling the Report Server Web Service
  • Custom assembly integration
  • Security considerations

Snapshots and Subscriptions

  • Report caching
  • Scheduling of report snapshots
  • Report history
  • Standard report subscriptions
  • Data-driven report subscriptions
What You Can Expect

At the end of this course, students will be able to:

  • Create tabular and list reports
  • Build expressions and understand how they are used within SSRS
  • Use global, field and parameter collections
  • Create Groups using the grouping pane for Details Group and Row Groups
  • Use parameters with stored procedures, with values on reports and unbound parameters
  • Create Matrix reports and see the new features of Matrix reports for SSRS 08
  • Deploy reports and use the report manager
  • Use SSRS Security, SSL and Data Source Security
  • Use Reporting Services APIs and Report Viewer Controls
  • Create a Web Service, a Web Service Subscription and Custom Assemblies
Who Should Take This Course

This course is designed for individuals who are SQL Server 2008 Reporting Services users.

Recommended Prerequisites

Knowledge of SQL Server 2008, SQL Server Management Studio, and SQL usage is highly recommended.

Training Style

Instructor led with 50% lecture and 50% lab.

« Hide The Details
Related Courses
Code Course Title Duration Level
DSSRPT
Maintaining, Troubleshooting, and Developing Solutions with Microsoft SQL Server 2008 Reporting Services
5 Days
I
Details
SSQE
Microsoft SQL Server 2008 Introduction to Querying
2 Days
I
Details
SSQFD
Microsoft SQL Server: Querying Data for Report Developers
3 Days
I
Details
SSRS1
SQL Server Reporting Services with BI Tools Part 1 - Report Builder, Data Tools, Cubes, and Tabular Reporting
5 Days
I
Details
MSBI
Accelerated Microsoft Business Intelligence: From SQL 2008 through SharePoint and Office 2007
4 Days
I
Details
SSRS2
SQL Server Reporting Services with BI Tools Part 2 - Report Server Admin, Extensive Tabular Modeling/Reporting, and C#/VB Extensions
5 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]