I. Implementing and Managing SQL Server 2008 Reporting Services
a. Lab 1: Install and Configure SSRS
i. Pre-Installation Checklist (min req's, editions, etc.)
ii. Install SSRS in non-clustered environment then a clustered environment
iii. Configuring Logging, Storage & Security
iv. Configuring Infrastructure (Internet deployment, My Reports)
v. Configuring Instances via Reporting Services Configuration Tool (Rsconfig.exe)
vi. Maintaining Instances via Reporting Services Web Services Library
b. Lab 2: SSRS Solution Management
i. Managing SSRS Reports Using Report Manager (data sources, creds, properties, linked reports)
ii. Deploying SSRS Report Solutions (BIDS, Report Builder, Report Server Catalog)
c. Lab 3: Secure and Schedule SSRS Reports
i. Implementing Security on a SSRS Solution
ii. Subscribing to a SSRS Report (delivery options, rendering format, data-driven)
iii. Scheduling a SSRS Report (shared vs report-specific, on-demand, caching, snapshots)
II. Developing Reporting Solutions in SQL Server 2008 Reporting Services
a. Lab 1: Create Reports
i. Creating Reports (Report Wiz vs Report Designer vs manual XML authoring)
ii. Designing Reports (report properties, page layout, headers/footers)
iii. Creating a Report Model for Report Builder (Model Designer vs Report Mgr)
iv. Importing Data Source Views into a Report Model Project
b. Lab 2: Define and Display Report Data
i. Create Datasets (CommandType, multidim, parameterized queries)
ii. Display Datasets in Data Regions (filters, group/sort, nesting, aggregates)
iii. Control Data by Applying Parameters (data types, defaults, bind, dynamics)
iv. Include Data using Sub Reports (business logic)
c. Lab 3: Monitor and Maintain SSAS
i. Extend a Report by Using Expressions (embedded functions & assemblies)
ii. Apply Formatting and Style (dynamic format expressions, static formatting)
iii. Configure Report Navigation Options (visibility, drilldown, drillthrough, URL)
