Customer Service or Enrol: 0800 282 353 or +44 1372 364610
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