|
Building
Reports using SQL Reporting Services (1 day)
Introduction
to Reporting Services
Reporting Services Components
Designing and Creating Reports
Report
Design Basics
Grouping
Working with Parameters
SubReports
Controlling Report Pagination
Publishing Reports
Interactive
Reports
Hiding
Report Items
Linking Reports
Document Maps
Writing
Expressions in Reporting Services
Manipulating
Data with Expressions
Commonly used Expressions
Global Collections
Reporting Services Functions
Writing Custom Code
Viewing
Reports
Publishing
and Printing Reports
“My Reports”
Scheduled / Cached Reports
Design
Considerations for Report Rendering
Publishing
and Printing Reports
“My Reports”
Scheduled / Cached Reports
Lab
Setup
|
Windows
2003 Server with IIS
.NET Framework 2.0
SQL Server 2005 with SQL Reporting Services and Business Intellegince
Development Studio
|
Pre-Requisites
|
Working
with databases and writing SQL Queries
|
Programming
with SQL Reporting Services (1 day)
Integrating
Reporting Services into Applications
Using
URL Access
Using the Web Service API to access reports
Web
Service API
Web
Service Features
Accessing SOAP API
Using the Web Service API to access reports
Building .net applications usng the Web service API
Device Infomation Settings
Using Reporting Services SOAP Headers
Exception Handling
Scripting with the rs Utility
Reporting
Services Extensions
Implementing
a Data Processing Extension
Code
Access Security
Understanding
Security Policies
Using Reporting Services Security Policy Files
Creating
Custom Assemblies
Referencing
Custom Assemblies
Deploying Custom Assemblies
Asserting Permissions
Accessing Custom Assemblies from Reports
Debugging Custom Assemblies
Working
with Ad hoc reports using Report Models
Introduction
to Report Builder
Introduction to Model Designer
Working with Entities, Folders, Perspectives, Roles, Source Fields and
Expressions
Publishing Report Models
Model Designer Object Relationship Diagram
Model Designer Query Properties
Model Designer Object Properties
Generate Models using Report Management Tools
Lab Setup
|
|
Windows
2003 Server with IIS
.NET Framework 2.0
SQL Server 2005 with SQL Reporting Services and Business Intellegince
Development Studio
Visual Studio.NET 2005
Pre-Requisites
|
|
.NET
Framework Programming
Knowledge of Designing and Deploying Reporting
Services Reports
|
Administrating
SQL Reporting Services (0.5 day)
Administering
Reporting Services
Administration
Tools
Administering Report Server Database
Managing Encryption keys
Administering Report Server web service and Windows Service
Managing Log files
Monitoring Performance
Deploying
Reports
Planning
a Reporting Services Deployment
Scripting Deployment and Administration Tasks
Initializing a Report Server
Configuring Components
Integrated Security and elevated permissions
Internationalization Considerations
Configuring
Reporting Services Security
Managing
Report Server Content
Managing
Data Source Connections
Managing
Subscriptions and Scheduling Reports
Lab Setup
|
|
Windows
2003 Server with IIS
.NET Framework 2.0
SQL Server 2005 with SQL Reporting Services
|
Pre-Requisites
|
|
SQL
Server Administration
|
|
|