|
|
SQL Server® 2005 Reporting Services: Hands-On
You Will Learn How To
- Leverage SQL Server 2005 Reporting Services to produce sophisticated reports
- Author robust reports that extract business intelligence out of your data
- Extract relevant report data using parameters and filters
- Render interactive reports with drill-down and drill-through features
- Deploy reports to a Report Server for centralised access and administration
- Secure reports in the Reporting Services environments
Course Benefits
The ability of an organisation to deliver business-critical reports to customers, partners, suppliers and employees is a vital component of remaining competitive. SQL Server Reporting Services augments SQL Server and other database management systems to meet these demanding requirements. In this course, you gain the knowledge and skills to write robust reports, mine important data and deliver reports for centralised access and administration.
Who Should Attend
Those designing, creating or delivering reports from a database with SQL Server 2005 Reporting Services. Previous exposure to any database system or spreadsheet data is assumed.
Hands-on Training
Throughout this course, you gain extensive experience creating and managing reports using Reporting Services. Exercises include:
- Authoring free-form reports including images, calculated fields and groups
- Implementing advanced navigation using drill down, drill through and document maps
- Deploying reports manually and automatically
- Creating cached instances, snapshots and subscriptions
- Configuring and testing security on report items
- Building and applying a currency converter function
Course Content
- Report types and formats
- SSRS Web Services
- Report Server
- Report Builder
- Model Designer
- Data sources: SQL Server, Oracle, OLE DB
- Single and Web farm deployment
- Tabular
- List
- Matrix
- Chart
- Constructing data sources and Datasets
- Inserting a data region, fields and images
- Calculating fields
- Built-in collections
- Integrating expressions in properties
- Applying conditional formatting
- Best practices for adding images
- Grouping to multiple levels
- Sorting the results
- Employing aggregate functions
- Returning subsets of data with query parameters
- Mapping report parameters to query parameters
- Building cascading report parameters
- Changing chart titles programmatically
- Designing reports for the user's national language
- Passing parameters to stored procedures
- Exploiting multivalued parameters
- Enhancing performance with filters
- Filters vs. query parameters
- Customising reports for different national languages
- Utilising sequential and nested regions
- Producing master/detail reports
- Linking subreports
- Revealing report detail with drill down
- Displaying related data with drill through
- Navigating with document maps
- Preparing reports for publishing
- Configuring project properties
- Units of deployment: Individual reports, projects, solutions, data sources
- Checking results with Report Manager
- On-demand or by subscription
- Improving performance with cached instances and snapshots
- Configuring snapshot history
- Making reports available via e-mail and fileshare
- Delivering reports flexibly through data-driven subscriptions
- Assigning users to roles
- Setting permissions on report items
- Granting and revoking system-level permissions
- Architecting report models with Model Designer
- Defining data source views
- Creating and refining models
- Deploying Report Builder to users
- Dragging and dropping entities onto charts and tabular reports
- Navigating data with infinite drill through
- Exploiting SSRS Web services
- Searching for information in a report
- Writing a Windows application with Report Viewer controls
- Mapping out the role of SSRS in a BI Infrastructure
- Distinguishing SSRS technology components
|
SQL Server is a registered trademark of Microsoft Corporation.
|
|
Print Friendly
E-mail a Colleague
Course PDF
Course FAQ
Home
