1-800-THE-TREE (1-800-843-8733)
 

SQL Server 2008 Reporting Services: Hands-On

 
Course: 140     Type: Hands-On Training     Duration: 4 Days

Quick Enroll    

You Will Learn How To
  • Leverage SQL Server 2008 Reporting Services to extract business intelligence from your data
  • Design reports and display your data graphically with enhanced visualization features
  • Integrate parameters, filters and interactive components into report design
  • Deploy and deliver relevant reports across the entire enterprise through Report Server and SharePoint
  • Safeguard reports with Windows and Forms Authentication
  • Easily create reports on demand with Model Designer and Report Builder

Course Benefits
SQL Server 2008 Reporting Services meets demanding requirements by providing a powerful and versatile reporting platform of data on SQL Server, Oracle or any other database system. In this course you gain the knowledge and skills to produce compelling reports and deliver reports through organization portals.

Who Should Attend
Those who need to design, create or deliver reports from relational or multidimensional databases, or plan to deploy Reporting Services within their organization. It is assumed that you have basic understanding of relational database management systems.

Hands-On Training
Throughout this course, you gain extensive experience creating and managing reports using Reporting Services. Exercises include:
  • Producing customized reports with expressions
  • Employing Tablix to produce new report formats
  • Leveraging advanced reporting charts with linear and radial gauges
  • Creating cached instances, snapshots and subscriptions
  • Deploying reports to SharePoint sites
  • Configuring and testing security on report items
  • Creating report models to empower users with ad hoc reporting

Course 140 Content
Introduction to SQL Server 2008 Reporting Services
  • Identifying deployment: native, integrated or single server
  • Managing web farm deployment with/without SharePoint
Developing Reports
Designing fundamental reports
  • Connecting to relational and multidimensional data sources
  • Generating a Tablix
  • Building an interactive chart
  • Creating reports with richly formatted text
Composing expressions
  • Computing fields
  • Managing built-in collections
  • Linking expressions to properties
  • Employing conditional formatting
Arranging and sorting data
  • Multiple level grouping and categorizing the results
  • Applying aggregate functions
Producing various outputs from a Tablix
  • Creating parallel dynamic groups report formats
  • Combining dynamic and static columns
  • Authoring reports with hierarchical rows and dynamic headers
Integrating Parameters and Filters
Incorporating parameters into reports
  • Yielding subsets of data with query parameters
  • Aligning report parameters to query parameters
  • Constructing cascading report parameters
  • Systematically altering chart titles
  • Transmitting parameters to stored procedures
  • Implementing multivalued parameters
Applying filters to report data
  • Augmenting performance with filters
  • Determining filters versus query parameters
Implementing Interactive Features
Gathering data regions in one report
  • Applying sequential and nested regions
  • Creating master/detail reports and linking subreports
Executing advanced data visualizations
  • Applying the radial and linear gauge
  • Customizing charts with scale breaks
  • Employing sparklines and bullet graphs
  • Charting KPIs from Analysis Services
Showing robust data with relevant detail
  • Drilling through report detail and drilling down report data
  • Maneuvering with document maps
Deploying and Delivering Reports
Deploying reports to the server
  • Furnishing reports for publishing and configuring project properties
  • Applying Report Manager for verifying results
Identifying delivery options
  • Electing on-demand or via subscription
  • Enhancing performance with cached instances and snapshots
  • Configuring snapshot history
  • Formatting different outputs
  • Exploiting the mail-merge functionality
Dispatching subscription reports
  • Publishing reports via e-mail and fileshare
  • Seamlessly delivering reports by data-driven subscriptions
Integrating reports with SharePoint
  • Checking results with SharePoint
  • Deploying to SharePoint
Safeguarding Reporting Services
Structuring content security
  • Comparing Windows and Forms authentication
  • Establishing permission levels on report items
Ensuring the RS system
  • Instituting varying levels of administrative roles
  • Allowing and withdrawing system-level permissions
Empowering Users with Ad Hoc Reporting
Designing models for users
  • Building personalized reports with Model Designer
  • Defining data source views
  • Creating and retiring models
Designing reports with Report Builder
  • Launching Report Builder to users across the enterprise
  • Dragging and dropping entities onto charts and tabular reports
  • Exploring data with infinite drill through
Reporting Services Programming
  • Controlling reports using URL access
  • Leveraging RS Web services
  • Designing a Windows application with Report Viewer controls
  • Embedding reports in applications

Related Courses
SQL Server is a registered trademark of Microsoft Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save Up to 45% per course on the standard tuition!

SQL Server 2008 Reporting Services: Hands-On
Upcoming Dates
Feb 24 - 27, 2009
 Washington, DC (Rockville, MD)
Mar 10 - 13, 2009
 Los Angeles
Mar 17 - 20, 2009
 Chicago (Schaumburg)
Mar 24 - 27, 2009
 Washington, DC (Reston, VA)
Apr 14 - 17, 2009
 Toronto
Apr 28 - May 1, 2009
 New York
May 5 - 8, 2009
 Ottawa
May 5 - 8, 2009
 Washington, DC (Alexandria, VA)
Jun 2 - 5, 2009
 Washington, DC (Rockville, MD)
Jun 23 - 26, 2009
 Chicago (Schaumburg)

SQL Server 2008 Reporting Services: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

SQL Server 2008 Reporting Services: Hands-On
SQL Server 2008 Reporting Services: Hands-On
Participants charting KPIs from an Analysis Services Cube.


CPE 23 Credits 1 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733