Customer Service or Enrol: 0800 282 353 or +44 1372 364610
 

SQL Server ®2008 Reporting Services: Hands-On

Course: 140   Type: Hands-On   Duration: 4 Days
Quick Enrol  

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 visualisation 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 organisation 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 organisation. 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 customised 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 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 categorising 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 visualisations
  • Applying the radial and linear gauge
  • Customising 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 personalised 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*:

Job Title:

Company*:

Post Code*:

Country*:
   Codes
Office Telephone*:

Extension:

E-mail*:

* Required

A Learning Tree representative will contact you to follow up your request for information.

Save £275
SQL Server 2008 Reporting Services
Course Schedule
17 - 20 Mar, 2009
London
26 - 29 May, 2009
London
25 - 28 Aug, 2009
London
24 - 27 Nov, 2009
London
Complete Schedule
On-Site Courses

Participants charting KPIs from an Analysis Services Cube.

£ 1,745 - Standard Tuition
Savings Plans
£ 1,120 - 10-Day Training Pass
£ 1,000 - Flex-Training Passport
£ 1,490 - 10-Training Vouchers
£ 1,600 - 5-Training Vouchers
£ 1,575 - Alumni Gold Tuition

All Saving Plans
 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610