|
Provided by: Affinity IT Training, LLC SQL Server 2005 Reporting Services |
 |
Training
Provided by Affinity IT Training, LLC
Learn how to use SQL Server 2005
Reporting Services to create, execute, and manage reports.
Learn how to create tabular, matrix (cross-tab),
and chart reports using Visual Studio 2005 and SQL Server 2005
Business Intelligence Studio. Explore creating reports with
groups, expressions, conditional formatting, and parameters.
Explore the deployment and printing of reports and the
export of reports to PDF, Excel, and other formats.
Gain a thorough understanding of Reporting Services security,
report snapshots, subscriptions, and the use of custom assemblies.
Discover how to integrate reports into your ASP.NET and other
applications
Audience:Technology professionals desiring to make the most of the powerful reporting capabilities of SQL Server 2005.
|
|
||||||||||
SQL Server 2005 Reporting Services
Objectives
- 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.
Outline
Introducing SQL Server Reporting Services
Tour of Features
Reporting Services Architecture
Reporting Services 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
Setup
- Access to SQL Server 2005 Reporting Services
- Databases and Accounts for students and Instructor
Seminar Pre-Requisites
- 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.
Training Materials
- Course Workbook
Jan08
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
