SQL Server 2005 Reporting Services Course
Course DescriptionIn this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. You'll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You'll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You'll gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. You'll also discover how to integrate reports into your ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you'll learn how to create ad-hoc reports using Report Builder and Report Model projects.
|
£895 3 day course Scheduled Dates: 09 January 2012 20 February 2012 11 April 2012 16 May 2012 27 June 2012 Location: PTR's Training Centre Wokingham, Berkshire. |
Course pre-requisites:
Familiarity with databases and the SQL language. Knowledge of SQL Server, Visual Studio .NET/2005, C# or VB helpful, but not required.
Topics covered on the 3 day SQL Server 2005 Reporting Services course
INTRODUCING SQL SERVER REPORTING SERVICES
- Tour of Features
- Reporting Services Architecture and Terminology
- Reporting Services Editions
- Taking Reporting Services for a Spin
CREATING REPORTS
- Deconstructing Reporting Services
- Shared Data Sources
- Creating Reports from Scratch
CALCULATIONS AND FORMATTING
- Creating Expressions
- Using the Global Collections
- Formatting Items
- Conditional Formatting
GROUPING AND SORTING
- Creating Groups
- Calculating Totals and Percentages
- Interactive Sorting
- Creating Drill-Down Reports
REPORT PARAMETERS
- Creating Report Parameters
- Creating Drop-Down Parameters
- Multi-Valued Parameters
- Debugging Parameter Issues
CREATING MATRIX REPORTS AND CHARTS
- Creating a Basic Matrix Report
- Matrix Subtotals
- Creating a Basic Chart
- Exploring the Charting Possibilities
MANAGING REPORTING SERVICES
- Deploying Reports and Data Sources
- Exporting Reports and Printing
- Using the Web-Based Report Manager
- Using SQL Server Management Studio-based Reporting Services Manager
REPORTING SERVICES SECURITY
- Two Parts to Reporting Services Security
- Securing Access to Reports
- Data Source Security
PROGRAMMING REPORTING SERVICES
- The Many Reporting Services APIs
- Integrating Reporting Services into Applications using URL Access
- Using the Report Viewer Controls
ADVANCED REPORTING SERVICES PROGRAMMING
- Using the Reporting Services Web Service
- Working with Custom Assemblies
SNAPSHOTS AND SUBSCRIPTIONS
- Caching and Snapshots
- Creating Standard Subscriptions
- Creating Data-Driven Subscriptions
- Managing Subscriptions
AD-HOC REPORTING WITH REPORT BUILDER
- The Report Builder Architecture
- Creating Report Model Projects
- Running Report Builder
Course Classification:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
09 January 2012 to 11 January 2012
20 February 2012 to 22 February 2012
11 April 2012 to 13 April 2012
16 May 2012 to 18 May 2012
27 June 2012 to 29 June 2012
View full schedule of Generic courses
View full schedule of SQL Server 2005 courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite SQL Server 2005 Training and bespoke SQL Server 2005 courses