SQL Server 2005 Reporting Services Overview
In this 3-day hands-on 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 empower your users to create ad-hoc reports using Report Builder and Report Model
projects.
Format
3-day lecture with hands-on labs.
Schedule of Public Classes
Sign Up Now!
Cost
$1395. (3 days)
Who Should Attend
Any programmer, power user, database professional, or data base administrator who wishes to learn just about everything there is to learn about SQL Server 2005 Reporting
Services.
Prerequisites:
- Familiarity with databases and the SQL language.
- Knowledge of SQL Server helpful but not required.
- Knowledge of Visual Studio .NET/2005 helpful but not required.
- Knowledge of C# or VB helpful but also not required.
What You'll Learn
In this course, you will learn to:
- Create complex reports employing expressions, the global collections, and conditional
formatting.
- Create reports with nested groups and multiple parameters.
- Manage reports using both the browser-based Report Manager and SQL Server Management
Studio-based Report Manager.
- Secure reports using integrated security and SSL.
- Program reports using URL Access, the Reporting Services Web Service API, the Report
Viewer controls, and custom assemblies.
- Employ report caching and create report snapshots.
- Create standard and data-driven report subscriptions.
- Empower users to create ad-hoc reports using Report Builder and the models you create
using Report Model projects.
Schedule of Public Classes
Sign Up Now!
If you need more information by phone, please call Deep Training at 888-366-5601
(or 206-282-5096) or send
email.
SQL Server 2005 Reporting Services (revised Dec-2006)
1. Introducing SQL Server Reporting Services
Tour of Features
Reporting Services Architecture
Reporting Services Terminology
Reporting Services Editions
Taking Reporting Services for a Spin
2. Creating Reports
Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch
3. Calculations and Formatting
Creating Expressions
Using the Global Collections
Formatting Items
Conditional Formatting
4. Grouping and Sorting
Creating Groups
Calculating Totals and Percentages
Interactive Sorting
Creating Drill-Down Reports
5. Report Parameters
Creating Report Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues
6. Creating Matrix Reports and Charts
Creating a Basic Matrix Report
Matrix Subtotals
Creating a Basic Chart
Exploring the Charting Possibilities
7. 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
8. Reporting Services Security
Two Parts to Reporting Services Security
Securing Access to Reports
Data Source Security
9. Programming Reporting Services
The Many Reporting Services APIs
Integrating Reporting Services into Applications using URL Access
Using the Report Viewer Controls
10. Advanced Reporting Services Programming
Using the Reporting Services Web Service
Working with Custom Assemblies
11. Snapshots and Subscriptions
Caching and Snapshots
Creating Standard Subscriptions
Creating Data-Driven Subscriptions
Managing Subscriptions
12. Ad-Hoc Reporting with Report Builder
The Report Builder Architecture
Creating Report Model Projects
Running Report Builder
Schedule of Public Classes
Sign Up Now!
If you need more information by phone, please call Deep Training at 888-366-5601
(or 206-282-5096) or send
email.
|
